Search found 1068 matches

by MattAllington
Sun Feb 09, 2020 7:34 am
Forum: PowerPivot/DAX
Topic: Rank table entries based on filter
Replies: 2
Views: 75

Re: Rank table entries based on filter

Your RANKX needs to use the same filters as your sales measure. You don’t provide the full measure nor the data model, so I can’t be more precise than that.
by MattAllington
Fri Nov 01, 2019 5:26 pm
Forum: PowerPivot/DAX
Topic: Total Volume of Product That Contain X Material
Replies: 1
Views: 547

Re: Total Volume of Product That Contain X Material

I don’t really understand the question, but you may find this article useful. https://exceleratorbi.com.au/many-many- ... explained/
by MattAllington
Fri Nov 01, 2019 5:23 pm
Forum: PowerPivot/DAX
Topic: Storing Dax Measures in a Database
Replies: 1
Views: 197

Re: Storing Dax Measures in a Database

How about building a power BI dataset, publish to PowerBi.com and then use Analyze in Excel to build your reports. That way you only need 1 master model
by MattAllington
Fri Nov 01, 2019 4:27 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Matrix in Page 42
Replies: 1
Views: 235

Re: Matrix in Page 42

It sounds to me like an issue with your relationship between the calendar table and the sales table. Go and check and make sure that it is correctly joined between the date columns in both tables
by MattAllington
Sun Oct 27, 2019 8:07 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Chapter 17 - Disconnected Table, p 151
Replies: 1
Views: 1555

Re: Chapter 17 - Disconnected Table, p 151

Any time IntelliSense does not assist you with a column name, the most likely reason is you are writing the formula incorrectly. IntelliSense only works when you write the syntax correctly. Perhaps you could post the formula you are writing here or check it against the book.
by MattAllington
Tue Oct 22, 2019 6:37 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Table Properties displays SQL statement only . . .
Replies: 4
Views: 540

Re: Table Properties displays SQL statement only . . .

This is a bug introduced after I wrote book. Which version of the book are you reading? Learn to write DAX, or supercharge power BI? In my newer version of the book I recommend using power query to load the data.
by MattAllington
Thu Oct 10, 2019 9:21 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Practice Exercise 60
Replies: 2
Views: 168

Re: Practice Exercise 60

The above is perfectly fine. In this case it is the same, in other cases this won’t work. Eg what are the total sales of these products? In that case you need to keep the filter and use calculate.
by MattAllington
Tue Oct 08, 2019 7:12 pm
Forum: PowerPivot/DAX
Topic: Accruals measure
Replies: 1
Views: 148

Re: Accruals measure

Well it can be done, but every DAX formula depends on the table structure. I suggest you create a meaningful set of realistic test data an share it along with your expected outcome.
by MattAllington
Tue Oct 08, 2019 7:11 pm
Forum: PowerPivot/DAX
Topic: Relationships, Power Pivot vs Access
Replies: 2
Views: 321

Re: Relationships, Power Pivot vs Access

These relationships are not a 1 for one substitute although I understand why you are asking. In short, you should prefer a star schema for the data loaded in power pivot. Read here https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/ You should not be aiming to simply replicate relat...
by MattAllington
Sat Oct 05, 2019 7:53 am
Forum: Power Query
Topic: What does orange colour icon means?
Replies: 1
Views: 532

Re: What does orange colour icon means?

It means the table has been loaded to the power pivot data model. There is indeed 2 copies of the table.

https://exceleratorbi.com.au/what-is-power-pivot/

Go to advanced search

cron