Search found 947 matches

by MattAllington
Tue Jul 03, 2018 6:27 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Error on Page 52
Replies: 1
Views: 97

Re: Error on Page 52

Hi YettyB. I assume you mean Learn to Write DAX. This book is 30 months old, and no one has every pointed this out to me :shock: This was fixed in my new edition, but obviously doesn’t solve this problem. The sentence refers to the table above, not below, and the “red” is the “box” drawn on the pivo...
by MattAllington
Sun Jun 24, 2018 11:10 am
Forum: PowerPivot/DAX
Topic: Loading data from Salesforce?
Replies: 1
Views: 132

Re: Loading data from Salesforce?

There is no way to avoid Power Query as this is the tool that connects to the data source. Power Query has 2 connection options for Salesforce (\Online Services\Salesforce Objects and \Online Services\Salesforce Reports) so I assume one of these will work. Just keep in mind that Power Query IS the t...
by MattAllington
Tue Jun 05, 2018 6:56 am
Forum: PowerPivot/DAX
Topic: PowerBI calculation problem
Replies: 2
Views: 189

Re: PowerBI calculation problem

I’m willing to take a look, but can you please
1. create a sample file including your formulas
2. Change the table names and column names to English (for context)
3. Show the answer you are expecting and where it is wrong.

Matt
by MattAllington
Mon Jun 04, 2018 4:30 pm
Forum: PowerPivot/DAX
Topic: Time Intelligence webinar- Evaluation of Year to Date Totals
Replies: 5
Views: 381

Re: Time Intelligence webinar- Evaluation of Year to Date Totals

It's not easy, but stick with it. Being able to ask questions definitely helps. Firstly, I don't know what formula you have for Total Sales YTD with ALL and MAX , but it is not correctly calculating YTD sales. This is the correct formula Sales YTD = CALCULATE ( [Total Sales], FILTER ( ALL &#...
by MattAllington
Mon May 28, 2018 12:49 pm
Forum: PowerPivot/DAX
Topic: Time Intelligence webinar- Evaluation of Year to Date Totals
Replies: 5
Views: 381

Re: Time Intelligence webinar- Evaluation of Year to Date Totals

Very good questions - this shows me that you are indeed thinking carefully about what is happening and that you want to understand. It is not intuitive, which is why it helps to have someone explain it. I will answer this question in my blog tomorrow morning (about 19 hours from now). https://excele...
by MattAllington
Sun May 27, 2018 7:18 am
Forum: PowerPivot/DAX
Topic: Completing information in the table Power BI
Replies: 1
Views: 265

Re: Completing information in the table Power BI

I recommend you read my article here https://exceleratorbi.com.au/best-pract ... -power-bi/

I find it hard to advise you because what you are showing is a long way from what I would recommend you starting with.
by MattAllington
Sun May 27, 2018 7:15 am
Forum: PowerPivot/DAX
Topic: PQ or PP for joins??
Replies: 1
Views: 175

Re: PQ or PP for joins??

Hi Suzy, I realise this is an old question. My view is transformations are best done closer to the source where needed. I can’t say if you “need” these transformations, but if you do, then do them in the source system first (if possible), then PQ, then PP. Have a read of Chris Webb’s article on one ...
by MattAllington
Thu Apr 26, 2018 12:17 pm
Forum: PowerPivot/DAX
Topic: how to multiply different columns with a dax measure [Solved]
Replies: 5
Views: 502

Re: how to multiply different columns with a dax measure [Solved]

this is very tough - I guess you know that already. I have no idea what that formula does but I know a lot about Power Pivot. I am willing to try to help you if you work with me on the problem. Please do the following. 1. create a sample excel workbook that contains the sample data. 2. load the data...
by MattAllington
Wed Apr 25, 2018 7:16 am
Forum: PowerPivot/DAX
Topic: Need Help for DAX using SSAS tabular model
Replies: 1
Views: 264

Re: Need Help for DAX using SSAS tabular model

Take a look at this. I will blog about this next week.

Edit:  I have now written the blog post – you can read it here https://exceleratorbi.com.au/show-all-i ... s-product/

invoices with products.xlsx
(215.27 KiB) Downloaded 23 times

Go to advanced search