Search found 1157 matches

by MattAllington
Wed Apr 07, 2021 8:00 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Combine IF, HASONEVALUE and Value functions query page. 107
Replies: 6
Views: 189

Re: Combine IF, HASONEVALUE and Value functions query page. 107

Hi Cindy The errors come from Intellisense. Intellisense looks at the function you are typing, it senses the valid syntax and will only allow you to write valid syntax. There are 2 functions. VALUE VALUES VALUE only accepts a text string, not a column. VALUES only accepts a column or table, not a te...
by MattAllington
Sun Apr 04, 2021 8:49 am
Forum: PowerPivot/DAX
Topic: From Cumulate to unit value
Replies: 1
Views: 70

Re: From Cumulate to unit value

To solve this, you need a lifetime to date time intelligence function. You should get a calendar table first, and use that in your pivot table. I don’t think it is mandatory in this case, but it is good practice. https://exceleratorbi.com.au/power-bi-calendar-tables/ Then you can write a measure som...
by MattAllington
Fri Apr 02, 2021 7:15 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Where to buy the book
Replies: 2
Views: 9165

Re: Where to buy the book

Where did you buy the book from? Did you buy a paperback or eBook? Please contact me via my website contact form
by MattAllington
Fri Apr 02, 2021 7:13 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Missing the years on the column session page 53-54
Replies: 1
Views: 115

Re: Missing the years on the column session page 53-54

The most common reason I see is because your relationship between the calendar table and the sales table is incorrect. Check the relationship and make sure it is the 2 date columns that are joined.
by MattAllington
Sun Mar 28, 2021 7:30 am
Forum: Help with the Book "Supercharge Power BI"
Topic: AVERAGE and AVERAGEX -two critical Page 77
Replies: 1
Views: 44

Re: AVERAGE and AVERAGEX -two critical Page 77

Item 1 is incorrect. The average function only accepts a single column. Item 2 looks fine to me. Try it again. Sometimes the error doesn’t reset until you click the tick in the formula bar. So if you typed 1, trigger the error and then type 2, the error still shows, but the error was with 1 and not 2.
by MattAllington
Sun Mar 21, 2021 10:20 am
Forum: PowerPivot/DAX
Topic: Using Date Range in Power Pivot
Replies: 2
Views: 389

Re: Using Date Range in Power Pivot

So you didn’t get the free help you were after, so you are criticising the people who provide free help? Is that it?
by MattAllington
Fri Mar 05, 2021 7:18 pm
Forum: Power Query
Topic: Studying Power Query, does this Data Model and relationships make sense?
Replies: 1
Views: 340

Re: Studying Power Query, does this Data Model and relationships make sense?

It’s hard to say from the picture. I would have thought transfers, transactions, credits and debits are all types of transactions and should be in a single, standardise fact table.
by MattAllington
Tue Feb 23, 2021 3:59 pm
Forum: PowerPivot/DAX
Topic: DISTINCTCOUNT Grand Total incorrect
Replies: 2
Views: 329

Re: DISTINCTCOUNT Grand Total incorrect

I’m on an iPad, so I can’t see your sample datamodel (just the pivot). At least conceptually, here is the problem with totalling distinctcount. Imagine you have sales by month by customer A,B,C Jan A=2 B=1 A=1 Feb A=4 C=3 How many distinct customers have purchased? Jan =2, Feb =2, right? But what do...
by MattAllington
Sat Feb 20, 2021 8:26 am
Forum: PowerPivot/DAX
Topic: Possible tweak to calendar ID last year calc
Replies: 1
Views: 129

Re: Possible tweak to calendar ID last year calc

This is a good approach if it helps. Another approach is to use Values(calendar[day of year]) to “harvest” which days of the year are in the current filter context. You can then to a time shift by removing all filters from the calendar, put a new filter on last year (by detecting the current year an...
by MattAllington
Wed Feb 17, 2021 6:33 am
Forum: PowerPivot/DAX
Topic: Formula working in Power BI but not in Power Pivot?
Replies: 1
Views: 116

Re: Formula working in Power BI but not in Power Pivot?

Check the data types of your columns to make sure they are not different in PP vs PBI.

Bonus tips
- read the error message that it gives when it doesn’t work
- consider if this should be a column or a measure https://exceleratorbi.com.au/calculated ... sures-dax/

Go to advanced search

cron