DAX Optimization
Proposed session for SQLBits 2026TL; DR
Two hours of intense DAX optimization techniques
Session Details
How do you optimize a DAX expression? In this two hours session, Alberto Ferrari analyzes some DAX expressions and Tabular models and, through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them.
As you will see, most optimizations are the direct application of best practices, but 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.
As you will see, most optimizations are the direct application of best practices, but 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.
3 things you'll get out of this session
Learn how to optimize DAX
Learn some internals about DAX
Learn how to measure performance of reports
Speakers
Alberto Ferrari's other proposed sessions for 2026
First Steps in DAX Optimization - 2026
Introducing DAX user-defined functions - 2026
Time Intelligence in Power BI - 2026
Why star schema is your best choice in Power BI - 2026