This comprehensive and authoritative guide will teach students the DAX language for business
intelligence data modeling and analytics. Leading Microsoft BI consultants Marco Russo and
Alberto Ferrari help students master everything from table functions through advanced code and
model optimization. They'll learn exactly what happens under the hood when you run a DAX
expression how DAX behaves differently from other languages and how to use this knowledge to
write fast robust code. If you want to leverage all of DAX's remarkable power and flexibility
this no-compromise "deep dive” is exactly what you need. Perform powerful data analysis with
DAX for Microsoft SQL Server Analysis Services Excel and Power BI Master core DAX concepts
including calculated columns measures and error handling Understand evaluation contexts and
the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD MTD previous
year working days and more Work with expanded tables complex functions and elaborate DAX
expressions Perform calculations over hierarchies including parent child hierarchies Use DAX
to express diverse and unusual relationships Measure DAX query performance with SQL Server
Profiler and DAX Studio