Search found 999 matches

by MattAllington
Wed Nov 14, 2018 8:24 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Visual Filters Page 117 of the book
Replies: 1
Views: 163

Re: Visual Filters Page 117 of the book

Sorry I missed this. Can you share your workbook here?
by MattAllington
Wed Nov 14, 2018 8:23 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Total Sales LY ID from Supercharge Excel
Replies: 1
Views: 1352

Re: Total Sales LY ID from Supercharge Excel

Mmm, sorry I missed this earlier. Did you sort it out? It should be <=MAX()
by MattAllington
Sun Nov 04, 2018 6:29 am
Forum: Power Query
Topic: Latest Date in Custom Column
Replies: 2
Views: 230

Re: Latest Date in Custom Column

What is the logic that needs to be applied to get your desired output?
by MattAllington
Mon Oct 29, 2018 5:26 am
Forum: PowerPivot/DAX
Topic: Complete date table in ACCESS
Replies: 10
Views: 781

Re: Complete date table in ACCESS

I don’t disagree with you or Marco. All I am saying is that I have never had a use case where I didn’t get the expected results. I agree it can happen, and it is easy to fix - just extend the calendar table as you have correctly stated.
by MattAllington
Fri Oct 26, 2018 5:53 pm
Forum: PowerPivot/DAX
Topic: Complete date table in ACCESS
Replies: 10
Views: 781

Re: Complete date table in ACCESS

Thanks for sharing. Yes I would also expect the behaviour you describe in the scenario. If you don’t have all the days on 2004, I would not expect it to fetch all the days in 2003. But it you are currently half way through 204 (day it is 1 July 2004, if I were comparing 2004 with 2003 then I wouldn’...
by MattAllington
Wed Oct 24, 2018 9:13 am
Forum: Power Query
Topic: Group and sum delimited values
Replies: 6
Views: 385

Re: Group and sum delimited values

When you split the column, go into advanced options and split to rows rather than columns. Then you can use group by and SUM to do the addition
by MattAllington
Mon Oct 22, 2018 6:08 am
Forum: PowerPivot/DAX
Topic: Mix multiple sources values in one pivot table
Replies: 2
Views: 153

Re: Mix multiple sources values in one pivot table

Please post a sample workbook
by MattAllington
Fri Oct 19, 2018 6:56 am
Forum: PowerPivot/DAX
Topic: How to calculate Variation between periods
Replies: 3
Views: 181

Re: How to calculate Variation between periods

The trouble with your period column is it is actually a text column with a human readable description of the period. On its own, this is not enough to do the job
by MattAllington
Thu Oct 18, 2018 6:02 am
Forum: PowerPivot/DAX
Topic: How to calculate Variation between periods
Replies: 3
Views: 181

Re: How to calculate Variation between periods

Welcome to a brave new world. There is a lot to learn, but you can learn it and you will be better for it. First unpivot your data so you have a single column of numbers and a “type” column. https://youtu.be/v8ccS5N6xFk Then you need a calendar table. https://exceleratorbi.com.au/power-pivot-calenda...
by MattAllington
Wed Oct 17, 2018 3:34 pm
Forum: PowerPivot/DAX
Topic: Data conversion + sum QTD/YTD
Replies: 1
Views: 156

Re: Data conversion + sum QTD/YTD

There is a lot you need to do here.

You need to unpivot your data using power query before you load. See here how to unpivot in Excel.

Then you need the custom time intelligence pattern. You can read about custom time intelligence in DAX in my blog.

Go to advanced search