Discover the true power of DAX in Microsoft Power BI and Fabric and build advanced DAX solutions for practical business scenarios
Key Features
Solve complex business problems leveraging Microsoft BI tools including Power BI and Fabric Develop a conceptual understanding of critical data modeling principles and best practices Learn the subtleties of DAX calculations, like evaluation context, context transition, and table functions
Book DescriptionThis book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of the modern Microsoft analytics platform based on Power BI and Fabric. Extreme DAX will first teach you the principles of business intelligence, good model design, semantic model architectures, and how DAX fits into it all. Then, you'll launch into detailed examples of DAX in real-world business scenarios such as inventory calculations, real estate planning, benchmarking, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with semantic models and common mistakes to look out for as you build advanced data aggregations. You'll deepen your understanding of DAX functions, visual calculations, and measures, and how and when they can be used to derive effective insights. Youll also learn about more advanced techniques like field parameters, calculation groups, user-defined functions and custom calendars. For each chapter, you'll be provided with PBIX files so that you can follow along and explore in your own timeWhat you will learn
Understand storage modes and modeling principles in semantic models Create reusable visual calculations Get to grips with the crucial concept of context Apply advanced context and filtering functions including TREATAS Implement semi-recursive calculation logic Work with week-based calendars and implement intra-day intelligence Implement linear regression and advanced goal-seeking Secure attributes and aggregation levels
Who this book is forExtreme DAX is written for analysts with some practical experience with DAX in Power BI, Fabric, or other Microsoft analytics tools. It will help you to upgrade your knowledge and work with analytical models more effectively. It explains new features that were recently added to the DAX language by not only introducing concepts but discussing sophisticated business scenarios as well. This way, Extreme DAX will inspire you to apply advanced DAX techniques in your own analytics projects.
Table of Contents
DAX in Business Intelligence
Model design
Using DAX
Context en filtering
Security with DAX
Dynamically changing visualizations
My immediate neighbourgs
Alternative Calendars
Working with autoexists
Exploring the future: forecasting & future values
Inventory analysis
Selling platform pay-out
Personnel planning vs workload
Michiel Rozema is one of the world's top Power BI experts. He holds a master's degree in mathematics and has worked in the IT industry for over 30 years as a consultant and manager. Michiel was the data insight lead at Microsoft Netherlands and launched Power BI in the country. He is the author of multiple books on Power Pivot and Power BI and has published video courses on Microsoft Fabric and Power BI on LinkedIn Learning. Michiel is founder of Quanto, organizer of the Power BI Summer School,, and speaker at many conferences on Power BI. He has been awarded the Microsoft MVP award since 2019. Madzy Stikkelorum has a master's degree in Mathematics and works at Quanto where she enjoys helping clients solve complex problems with Microsoft Power BI solutions. She is co-author of the book Microsoft Power BI Visual Calculations: Simplifying DAX and she launched the video training Mastering Business Intelligence with DAX, Power BI, and Excel in 2025 with Michiel. Madzy lives with her husband and two sons in the Netherlands, and in her spare time she loves to read, bake, and work on creative projects of all kindswith or without sons, with mixed results regarding creativity and complexity Henk Vlootman is a senior global Power Platform, Power BI, and Excel business consultant. Every year since 2013, Henk has received the Microsoft MVP award for his outstanding expertise and community leadership. Henk is one of founders of the Dutch Power BI user group and the organizer of the Power BI Summer School, and has been a speaker at many conferences on Power BI all over the world. He is also the author of two Excel and two Power Pivot / Power BI books. He started his career in 1992 with his own company, then as an Excel consultant. Nowadays he runs the consultancy company Quanto, specialists in Power BI, together with fellow MVP Michiel Rozema.
