Order of Evaluation in DAX & Variables

RACHEL DYER (SkyPoint CSG)

 

Rachel Dyer is the Vice President of Analytics at SkyPoint CSG with in-depth expertise of the Microsoft BI stack and dimensional modeling. She has a broad management background and strong communications skills, coupled with considerable technical experience in platform implementation. She is more commonly known as the Queen of DAX or Rachel DAXie Dyer. 

 

What order does DAX use when you nest more than one CALCULATE function? How does it behave when context transition is also happening at the same time? We’ll look at how this works and give you the logic and some examples.

Variables are so important that they were the driving force behind a new edition of The Definitive Guide to DAX that is in the works. We’ll review the fundamentals of variables and show some common use cases that you are sure to run into.

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.