Search found 985 matches

by MattAllington
Mon Sep 10, 2018 6:16 am
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 349

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

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

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

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

Interesting. Can you post a sample workbook?
by MattAllington
Sat Sep 01, 2018 8:04 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Ch19 Multiple Data Tables missing data
Replies: 4
Views: 448

Re: Ch19 Multiple Data Tables missing data

Hi Dave

Sorry I missed this post, and thanks for bringing this to my attention. I have fixed the issue - the budget files are now included in the download. Here they are here for you too.

Budget Files.xlsx
(11.78 KiB) Downloaded 18 times
by MattAllington
Wed Aug 22, 2018 3:09 pm
Forum: PowerPivot/DAX
Topic: Week Number for Fiscal Year
Replies: 3
Views: 121

Re: Week Number for Fiscal Year

184 moves a calendar year to a fin year. It doesn't solve the first day of week issue. You should get the first day of week working correctly first with a calendar year, and then +184 to shift into the next year. so, there is an optional parameter for the week of year as shown below. Use the menu fi...
by MattAllington
Wed Aug 22, 2018 1:26 pm
Forum: PowerPivot/DAX
Topic: Week Number for Fiscal Year
Replies: 3
Views: 121

Re: Week Number for Fiscal Year

well if you are happy to take the week number that is calculated, you can just add 184 to the date before doing the week number. Just add the regular week number first, then go back and edit the code and place +184 after the date
by MattAllington
Sun Aug 19, 2018 9:40 am
Forum: Power Query
Topic: Add Conditional Column
Replies: 2
Views: 337

Re: Add Conditional Column

So you are saying you want to concatenate the descriptions from multiple duplicates into 1? I hunk this is doable. Please post some sample data in a spreadsheet and I will take a look.
by MattAllington
Thu Aug 16, 2018 7:37 pm
Forum: Testing
Topic: test link
Replies: 3
Views: 547

Re: test link

Another test reply to check signatures
by MattAllington
Thu Aug 16, 2018 7:33 pm
Forum: Testing
Topic: test
Replies: 2
Views: 112

Re: test

Test reply to check signature

Go to advanced search