Chapter 16. Optimizing DAX

This is the last chapter of the book and it is time to use all the knowledge you have gained so far to approach the most fascinating topic about DAX: optimizing formulas. You learned how the VertiPaq engine works, how to read a query plan and the internals of the formula engine and the storage engine. Now all the pieces are in place and you are ready to learn how to use that information to write fast code.

However, before approaching this chapter, there is one very important warning. Do not expect to learn best practices or a simple way to write fast code. Simply stated: there is no way in DAX to write code that is always the fastest. The speed of a DAX formula depends on many factors, the most important of which, unfortunately, ...

Get The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.