DAX ADDCOLUMNS [DAX Virtual Table Series - Ep. 2]

[@tablulartech4147]

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??

[@JBartlett_DMU]

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?

[@JBartlett_DMU]

@@HerseyHouseBI Why does it work in a column, but not in a measure?

[@bhakthasingh8198]

Excellent tutorial

[@PragmaticWorks]

Glad you liked it! Thanks!

[@terrylee2094]

Wow that is so useful, thanks

[@PragmaticWorks]

Thanks for watching!

[@dibakarroy3853]

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

[@pakcanadatradingllc.2293]

Dear sir no files found plz guide

[@LukaszKobierski]

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?

[@PragmaticWorks]

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

[@LukaszKobierski]

@@PragmaticWorks Working now! :) Thanks!

[@PragmaticWorks]

@@LukaszKobierski Good to hear! Thanks again for watching!