The Definitive Guide to DAX, 3rd edition

Published by Microsoft Press (December 16, 2025) © 2026

  • Alberto Ferrari
  • Marco Russo
Products list

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

Need help?Get in touch