The Definitive Guide to DAX, 3rd edition
- Alberto Ferrari |
- Marco Russo |
Title overview
Unlock the full potential of your data with this new edition of The Definitive Guide to DAX by Alberto Ferrari and Marco Russo, the ultimate resource for mastering the DAX language used in Microsoft Power BI, SQL Server Analysis Services, and Excel. Whether you're a BI professional or an Excel power user, this comprehensive guide will transform the way you approach data modeling and analysis. With their unparalleled expertise, Alberto and Marco take you on a journey through the unique and complex concepts of DAX, equipping you with the skills to write efficient code and customize calculations for more insightful reports. Updated with the latest features, this third edition introduces new time intelligence functions and visual calculations, ensuring you're at the forefront of business intelligence innovation. Dive into this essential guide and elevate your data analysis capabilities to new heights, making strategic decision-making more informed and impactful.
Table of contents
1 Introduction to learning DAX
2 Introducing DAX
3 Introducing the filter context and CALCULATE
4 Manipulating the filter context
5 Introducing the row context and the context transition
6 Understanding basic table functions
7 Understanding variables
8 Understanding the evaluation context
9 Working with the evaluation context
10 Understanding user-defined functions in DAX
11 Working with tables
12 Understanding window functions in DAX
13 Time intelligence calculations
14 Understanding visual calculations
15 Understanding calculation groups
16 Inspecting the filter context and managing hierarchies
17 Authoring queries
18 Advanced DAX concepts
19 Practicing DAX with advanced examples
Author bios
Alberto Ferrari and Marco Russo are renowned experts in the fi eld of business intelligence and data analysis, specializing in the DAX language and Microsoft Power BI. As the founders of sqlbi.com, they have established a leading platform for DAX tutorials and articles, sharing their extensive knowledge with a global audience. With a deep understanding of DAX since its early days in Power Pivot, Marco and Alberto have become influential figures in the BI community, regularly speaking at prestigious international conferences such as Microsoft Fabric Conference, PASS Summit, and SQLBits.