Below is a complete list of chapters from the book Mastering DAX in Power BI by Lazar Jovovic. This book is structured to take you from foundational DAX concepts all the way to advanced, real-world reporting and performance optimisation.

Whether you're just starting with Power BI or you're an experienced developer looking to refine your skills, each chapter builds on practical techniques and examples that work in the real world.

🔹 Part 1: Introduction to DAX and Power BI

1. What Is DAX

2. Data Types in DAX

3. DAX Syntax and Operators

🔹 Part 2: Building Blocks of DAX

4. Function Groups in DAX

5. Calculated Columns

6. Measures

7. Using Calculated Tables in Power BI

8. Row Context and Filter Context

🔹 Part 3: Aggregations and Time Intelligence

9. Dynamic Row-Level Security (RLS)

10. Advanced Aggregations

11. Iterators

12. Variables in DAX

13. Time Intelligence Functions

🔹 Part 4: Advanced DAX Functions

14. Mastering Context Transition with CALCULATE

15. Working With Related Tables

🔹 Part 5: Optimising DAX and Performance Tuning

16. Handling Complex Data Models

17. DAX for Financial Reporting

18. DAX for Sales and Marketing Analytics

19. DAX for HR and Operations

20. Bonus: Implementing the Pareto Principle with DAX

🔹 Part 6: DAX in Power BI and Beyond

21. Advanced Data Visualisations with DAX

22. DAX in Power Pivot and SSAS

🔹 Part 7: Conclusion and Best Practices

23. Best Practices in DAX Development

24. Performance Tuning in DAX

25. Common DAX Mistakes and How to Fix Them

Each chapter includes:

• Real-world examples and use cases

• Step-by-step exercises using the AdventureWorks DW dataset

• Best practices for performance and maintainability

• Downloadable resources to follow along in Power BI

👉 Want to preview the book? Read a free sample here »