Search found 1159 matches

by MattAllington
Fri May 14, 2021 2:50 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Matrix vs table
Replies: 1
Views: 26

Re: Matrix vs table

In the first example Sales[ProductKey] on rows and Products[Weight] on values, the sales table doesn't filter the products table, hence the sum of weight is the same number you would get if you put weight in a card on its own - it is just the total of the weight column regardless of any filter on th...
by MattAllington
Thu Apr 22, 2021 7:52 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Creating Saletbl-Calendartbl Relationship Pg 32 3RD Ed.
Replies: 2
Views: 204

Re: Creating Saletbl-Calendartbl Relationship Pg 32 3RD Ed.

Hi Stanton. Power BI was designed to work with dates. Older versions of SSAS and SQL were often more efficient with date keys. Date keys are normally a surrogate for dates (hence the term surrogate key). Technically it is possible to use a surrogate date key in the sales table and the same surrogate...
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: 365

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: 131

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: 9580

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: 202

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: 108

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: 456

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: 391

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: 400

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...

Go to advanced search

cron