To answer the question raised by James, In a Calculate Function the Table expression first gets evaluated before aggregation. In case of variable, the expression is evaluated first. So, say in March row context, though the DATESINPERIOD is changing the context to 3 months i.e. Jan, Feb and Mar but since I have hardcoded the aggregation to only March by using the variable, the aggregation is happening only on march month. So, effectively context transition is getting nullified
Hi Lukasz. Sorry for the glitch there. This new link should work for you. Let us know how it goes if you don't mind and again thanks for your patience. tinyurl.com/58t695ej
![SELECTCOLUMNS [DAX Virtual Table Series - Ep. 3]](http://i.ytimg.com/vi/0dQZy2N1wZE/mqdefault.jpg)
![SELECTCOLUMNS [DAX Virtual Table Series - Ep. 3]](/img/tr.png)
![Data Lineage [DAX Virtual Table Series - Ep. 4]](http://i.ytimg.com/vi/o2mHZbqidkw/mqdefault.jpg)
Excellent tutorial
Glad you liked it! Thanks!
Hi, as u mention in the first vdo of the series that VALUES with variables won't work. Can you give bit of insights why it worked in this case??
Wow that is so useful, thanks
Thanks for watching!
At 8:47 -- Can you explain why calling the VALUES() function in a VAR assignment works in this context, but didn't work in your last video?
@@HerseyHouseBI Why does it work in a column, but not in a measure?
To answer the question raised by James, In a Calculate Function the Table expression first gets evaluated before aggregation. In case of variable, the expression is evaluated first. So, say in March row context, though the DATESINPERIOD is changing the context to 3 months i.e. Jan, Feb and Mar but since I have hardcoded the aggregation to only March by using the variable, the aggregation is happening only on march month. So, effectively context transition is getting nullified
Dear sir no files found plz guide
Hi! I'm trying download file and after fill in form I got new screen about login to pragmatic works account. I can not login there. Is that right?
Hi Lukasz. Sorry for the glitch there. This new link should work for you. Let us know how it goes if you don't mind and again thanks for your patience. tinyurl.com/58t695ej
@@PragmaticWorks Working now! :) Thanks!
@@LukaszKobierski Good to hear! Thanks again for watching!