Search found 967 matches

by MattAllington
Thu Aug 16, 2018 7:37 pm
Forum: Testing
Topic: test link
Replies: 3
Views: 74

Re: test link

Another test reply to check signatures
by MattAllington
Thu Aug 16, 2018 7:33 pm
Forum: Testing
Topic: test
Replies: 2
Views: 49

Re: test

Test reply to check signature
by MattAllington
Thu Aug 16, 2018 7:29 pm
Forum: Testing
Topic: test link
Replies: 3
Views: 74

Re: test link

Test
by MattAllington
Thu Aug 16, 2018 4:29 pm
Forum: Testing
Topic: test link
Replies: 3
Views: 74

test link

by MattAllington
Thu Aug 16, 2018 4:27 pm
Forum: Testing
Topic: test
Replies: 2
Views: 49

test

test
by MattAllington
Wed Aug 15, 2018 9:19 am
Forum: PowerPivot/DAX
Topic: I have a problem with the dax formula. Calculation of partner commission
Replies: 1
Views: 72

Re: I have a problem with the dax formula. Calculation of partner commission

the numbers in your input and output are the same. So what it is you are trying to do? Is it to change the Name descriptor so it shows the name of the level above as part of the hierarchy? Is this a realistic sample of data? eg in your sample data, the same name never appears twice at all, ever acro...
by MattAllington
Fri Aug 10, 2018 7:57 am
Forum: PowerPivot/DAX
Topic: AUS Date Chnged to US in Power Pivot Data Model
Replies: 1
Views: 894

Re: AUS Date Chnged to US in Power Pivot Data Model

I assume your PC is configured for the AUS region. Assuming so, try loading the data using Power Query. In Power Query, there is an option to change the data format "Change Type\Using Locale".

Discover more about my Dax Book.
by MattAllington
Tue Aug 07, 2018 6:44 am
Forum: PowerPivot/DAX
Topic: DAX formula help required
Replies: 6
Views: 984

Re: DAX formula help required

Sorry, I’m not clear. Did you write 2 different measures, one for cust type G and one for cust type S? When you put these 2 measures into a table with individual customers, do the 2 measures give the correct answer for the correct customer type? All that matters is that the correct measure gives the...
by MattAllington
Sun Aug 05, 2018 7:38 am
Forum: PowerPivot/DAX
Topic: DAX formula help required
Replies: 6
Views: 984

Re: DAX formula help required

I wouldn’t do it this way. How about write a measure that gives the correct 60 day total. Then write another measure that gives the correct 30 day total. Finally write a measure that switches between the other 2 measures depending on the type of customer. You can use variables and do this within one...
by MattAllington
Sat Aug 04, 2018 8:06 am
Forum: PowerPivot/DAX
Topic: DAX formula help required
Replies: 6
Views: 984

Re: DAX formula help required

My book is designed as a teaching aid. If you read it from front to back and do the exercises, you will know how to solve this problem. For now, read chapter 14, the section titled “custom time intelligence”. If you follow the pattern you should be fine, even if you don’t understand it until you com...

Go to advanced search

cron