Search found 1067 matches

by MattAllington
Fri Nov 01, 2019 5:26 pm
Forum: PowerPivot/DAX
Topic: Total Volume of Product That Contain X Material
Replies: 1
Views: 478

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

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

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

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

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

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

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

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

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/
by MattAllington
Sat Oct 05, 2019 7:50 am
Forum: Power Query
Topic: Delete Add Tables from Power Query
Replies: 1
Views: 329

Re: Delete Add Tables from Power Query

Are these tables loaded in Power Pivot? If so, go to Excel, open the queries pane, right click on the query you want to remove, select “load to” and then deselect “add to data Model”

Go to advanced search