Understanding DAX evaluation contexts using the TE3 DAX Debugger

To truly master the DAX language, one must understand the underlying concepts of evaluation contexts and context transition. These concepts can be difficult to grasp by looking at code snippets alone. In this session, we will use Tabular Editor 3’s DAX Debugger feature, as a shortcut to help us visualize and understand these concepts in action. With this understanding, we will take a look at the newly released window functions in DAX, to see how these can be used to simplify rolling aggregations, comparisons, and other types of analytic calculations, that were traditionally difficult to write and performed poorly in DAX.