Search found 14 matches

Wed Jan 31, 2018 10:39 am
Forum: PowerPivot/DAX
Topic: Replicating the Behaviour of the IN Keyword in Excel 2013 DAX
Replies: 1
Views: 1085

Re: Replicating the Behaviour of the IN Keyword in Excel 2013 DAX

https://www.sqlbi.com/articles/from-sql-to-dax-in-and-exists/

Excel 2016 added the IN operator, but for 2013 you have to look elsewhere.

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

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?
Wed Jan 17, 2018 2:13 pm
Forum: PowerPivot/DAX
Topic: Context transition in measures
Replies: 13
Views: 3711

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. ...
Wed Jan 17, 2018 12:46 pm
Forum: PowerPivot/DAX
Topic: Context transition in measures
Replies: 13
Views: 3711

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...
Wed Nov 15, 2017 10:31 am
Forum: PowerPivot/DAX
Topic: Dax Formula for Pivot with Running total and Switch statement
Replies: 2
Views: 1484

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...
Thu Aug 24, 2017 9:32 am
Forum: PowerPivot/DAX
Topic: Power-planner
Replies: 1
Views: 1204

Re: Power-planner

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

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 ...
Wed Nov 02, 2016 6:15 pm
Forum: PowerPivot/DAX
Topic: Understanding context transition
Replies: 16
Views: 9074

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...
Wed Jul 20, 2016 3:02 am
Forum: PowerPivot/DAX
Topic: DATESQTD alternative: always the full quarter
Replies: 7
Views: 3629

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...
Fri May 20, 2016 5:06 pm
Forum: PowerPivot/DAX
Topic: DATESQTD alternative: always the full quarter
Replies: 7
Views: 3629

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[...