DAX optimization examples




How do you optimize a DAX expression? In this session we analyze some DAX expressions and Tabular models and we will look at how to optimize them through the usage of DAX Studio and some understanding of the VertiPaq model.
As you will see, most optimizations are the direct application of best practices. However, the session has the additional takeaway of understanding what kind of performance you should expect from your formulas, and the improvement you might expect from learning how to optimize the model and the code.



 Enclose code in comments with <PRE></PRE> to preserve indentation.