Search found 13 matches

by matthew
Thu Jan 18, 2018 7:31 am
Forum: PowerPivot/DAX
Topic: Context transition in measures
Replies: 13
Views: 188

Re: Context transition in measures

Marc1988, did you see my second post after post with link to Jeffrey Wang article?

If so, was it not clear?
by matthew
Wed Jan 17, 2018 2:13 pm
Forum: PowerPivot/DAX
Topic: Context transition in measures
Replies: 13
Views: 188

Re: Context transition in measures

A couple more comments if i may: @Marc1988 wrote: The result is still the same of bikes as had i just written this: Calculate ( [SalesBikes]; ProductName="Seat"). I actually expected to turn around the evaluation order because i applied context transition but I didnt get what i hoped for. ...
by matthew
Wed Jan 17, 2018 12:46 pm
Forum: PowerPivot/DAX
Topic: Context transition in measures
Replies: 13
Views: 188

Re: Context transition in measures

I posted this in the comments of Marco’s post too, but I find this snippet from Jeffrey Wang article helpful: Calculate function performs the following operations: 1. Create a new filter context by cloning the existing one. 2. Move current rows in the row context to the new filter context one by one...
by matthew
Wed Nov 15, 2017 10:31 am
Forum: PowerPivot/DAX
Topic: Dax Formula for Pivot with Running total and Switch statement
Replies: 2
Views: 308

Re: Dax Formula for Pivot with Running total and Switch statement

Great you got it resolved, but looking at your original formula keep one thing in mind. The Switch statements are executed in order and stop at the first "True" statement. So in this: SWITCH (TRUE(), [RT Reg Hours] >= 40, ( [RT Reg Hours]-40)+ ([Sum of OT Hrs]), [RT Reg Hours] >= 48, ( [RT...
by matthew
Thu Aug 24, 2017 9:32 am
Forum: PowerPivot/DAX
Topic: Power-planner
Replies: 1
Views: 287

Re: Power-planner

I see you posted a response to me just now over at MrExcel. Thanks.
by matthew
Thu Aug 24, 2017 3:22 am
Forum: PowerPivot/DAX
Topic: Power-planner
Replies: 1
Views: 287

Power-planner

Matt Allington, I noticed in the comments on a mrexcel blog post you mentioned power-planner as an option for tracking comments (or something like that). I demo'd the product but ultimately didn't purchase it so I was curious if you have had an experience with it and what your thoughts are on it. I ...
by matthew
Wed Nov 02, 2016 6:15 pm
Forum: PowerPivot/DAX
Topic: Understanding context transition
Replies: 16
Views: 3235

Re: Understanding context transition

Great discussion. Never can have too much discussion on DAX. They explain it correctly but it is hard, and there are layers of complexity. It is almost a case that if you don't actually understand, then you think you understand - but your understanding is wrong. Seriously. This is me. On a lot of th...
by matthew
Wed Jul 20, 2016 3:02 am
Forum: PowerPivot/DAX
Topic: DATESQTD alternative: always the full quarter
Replies: 7
Views: 1657

Re: DATESQTD alternative: always the full quarter

It does work. TOTALQTD spelled out is "Total Quarter-to-Date". When you select Feb the formula is doing just that - totaling all values-to-date. "to-date" is February because that is the maximum value in the current filter context. To do what you wanted you would need to do somet...
by matthew
Fri May 20, 2016 5:06 pm
Forum: PowerPivot/DAX
Topic: DATESQTD alternative: always the full quarter
Replies: 7
Views: 1657

Re: DATESQTD alternative: always the full quarter

Personally i think you would be way better off having a separate Calendar table with all dates inclusive of the range you need to cover. Mark as "Date" table. Then use the native time intelligence functions to get your totals. Total for QTD := TOTALQTD ( fact_table[turnover], Calendar[...
by matthew
Tue Apr 19, 2016 4:30 pm
Forum: PowerPivot/DAX
Topic: YTD Calculation Query
Replies: 4
Views: 1348

Re: YTD Calculation Query

I know this post is a few weeks old but I am new to this forum and had a couple of questions/comments on this post. I apologize in advance if this is too verbose a response. First, does the code: RevYTD-FY:=TOTALYTD([SumRevenue],'Calendar'[Date],"30/6") return a different value than the la...

Go to advanced search