Search found 981 matches

by MattAllington
Wed Sep 19, 2018 7:27 am
Forum: PowerPivot/DAX
Topic: Complete date table in ACCESS
Replies: 5
Views: 77

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

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

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

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

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

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

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

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...
by MattAllington
Fri Sep 07, 2018 8:39 am
Forum: PowerPivot/DAX
Topic: Creating Categories Based on Order of Test Completion
Replies: 1
Views: 110

Re: Creating Categories Based on Order of Test Completion

One issue I see is that these groups are not mutually exclusive. eg person 6 qualifies for groups 6, 5, 3. How should this be handled?
by MattAllington
Wed Sep 05, 2018 12:14 pm
Forum: Excel
Topic: Data model for a double-entry bookkeeping system in Excel/PowerPivot?
Replies: 1
Views: 146

Re: Data model for a double-entry bookkeeping system in Excel/PowerPivot?

Interesting. Can you post a sample workbook?

Go to advanced search