Search found 983 matches

by MattAllington
Fri Sep 21, 2018 7:57 am
Forum: PowerPivot/DAX
Topic: Combine 2 pivot tables into one pivot table
Replies: 1
Views: 20

Re: Combine 2 pivot tables into one pivot table

You can't combined 2 pivot tables. A pivot table is a visualisation tool for data. You need to combine the underlying data. You can do that in Power Pivot.
by MattAllington
Fri Sep 21, 2018 7:56 am
Forum: PowerPivot/DAX
Topic: Help with DATEDIFF function
Replies: 2
Views: 45

Re: Help with DATEDIFF function

I realise you didn't write this, but I can almost guarantee that this is the wrong approach. Can you take a step back and explain what data you have and what you are trying to do here. It is highly likely there is a better approach than this formula.
by MattAllington
Wed Sep 19, 2018 7:27 am
Forum: PowerPivot/DAX
Topic: Complete date table in ACCESS
Replies: 5
Views: 82

Re: Complete date table in ACCESS

If you don't have it, please download the sample files from my website again https://exceleratorbi.com.au/supercharg ... /#download There is a file called 7 tables in that zip file
by MattAllington
Mon Sep 17, 2018 8:21 am
Forum: PowerPivot/DAX
Topic: Complete date table in ACCESS
Replies: 5
Views: 82

Re: Complete date table in ACCESS

I understand why you are asking. Marco Russo keeps telling me that the calendar table should go to the end of the year. I don't have that, but I have an Excel version in the download that you can extend yourself if you like. FYI, I have written hundreds of formulas using the current incomplete calen...
by MattAllington
Mon Sep 17, 2018 7:37 am
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 325

Re: SUMX Giving Incorrect Grand Total

It is currently not possible to change the headings in a table based on a slicer. You could write a new measure and put it in a card above the heading if you like. something like this (you will have to change the table and column names)

=SELECTEDVALUE(Table[C2])
by MattAllington
Tue Sep 11, 2018 6:47 am
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 325

Re: SUMX Giving Incorrect Grand Total

The formula you have pasted is not the one I provided. You are missing a close bracket before the divide and you have an extra one at the end
by MattAllington
Tue Sep 11, 2018 6:25 am
Forum: Power Query
Topic: Max query with second condition [Solved]
Replies: 2
Views: 88

Re: Max query with second condition [Solved]

Just put a filter to remove the zeros, then group by and take the first record.
by MattAllington
Mon Sep 10, 2018 7:08 pm
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 325

Re: SUMX Giving Incorrect Grand Total

Sorry, I can’t tell from what you have pasted what the issue is. Can you just paste the exact formul you are typing?
by MattAllington
Mon Sep 10, 2018 6:16 am
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 325

Re: SUMX Giving Incorrect Grand Total

My formula had an error, but was right for the model. Just swap out the table name with yours below.

SUMX(values(table[cbu]), CALCULATE(sum(table[CY MTD])/sum(table[PY MTD])))
by MattAllington
Sun Sep 09, 2018 8:08 am
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 325

Re: SUMX Giving Incorrect Grand Total

I can help you, but I can’t give an exact answer from the information you have provided. Read my article explaining SUM vs SUMX . The exact formula to need depends on the data model. Eg I can’t be sure if CY MTD and PY MTD are measures or columns, or if there are any other tables, or if CBU comes fr...

Go to advanced search