Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel
English
By (author): Alberto Ferrari Marco Russo
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