The Definitive Guide to DAX: Mastering the semantic model expression language for Microsoft Power BI, Fabric, and Excel, 3rd Edition
- By Alberto Ferrari, Marco Russo
- Published Dec 8, 2025 by Microsoft Press. Part of the Business Skills series.
eBook
- Your Price: $46.39
- List Price: $57.99
- Estimated Release: Dec 8, 2025
- Includes EPUB and PDF
- About eBook Formats
This eBook includes the following formats, accessible from your Account page after purchase:
EPUB
The open industry format known for its reflowable content and usability on supported mobile devices.
PDF
The popular standard, used most often with the free Acrobat® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Also available in other formats.
Description
- Copyright 2026
- Edition: 3rd
- eBook
- ISBN-10: 0-13-824480-4
- ISBN-13: 978-0-13-824480-4
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.
Sample Content
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 (TBD)
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