Beat the rise! Delivery fees are going up soon. INFO

Close Notification

Your cart does not contain any items

Extreme DAX

Take your Power BI and Fabric analytics skills to the next level

Michiel Rozema Madzy Stikkelorum Henk Vlootman Jeroen ter Heerdt

$112.95   $90.51

Paperback

Not in-store but you can order this
How long will it take?

QTY:

English
Packt Publishing Limited
22 May 2026
Master advanced DAX in Power BI and Microsoft Fabric to build scalable semantic models, solve complex business problems, and deliver high-impact analytics using real-world scenarios and proven techniques.

Key Features

Solve complex business problems with advanced DAX in Power BI and Fabric Build scalable semantic models using modern data modeling best practices Master evaluation context, calculation groups, and advanced DAX techniques

Book DescriptionThis book helps experienced analysts unlock the full potential of DAX in Power BI and Microsoft Fabric to build scalable, production-ready analytics solutions. You’ll begin by strengthening your understanding of semantic models, data modeling, and evaluation context—the foundation of reliable analytics. Instead of isolated examples, the book uses real-world scenarios such as inventory analysis, benchmarking, and data security to show how advanced DAX calculations are applied in practice. As you progress, you’ll master advanced techniques including context transition, table functions, calculation groups, field parameters, and custom calendars. You’ll also explore analytical methods such as regression and goal-seeking to generate deeper insights from your data. With step-by-step guidance and practical PBIX examples, you’ll learn how to design efficient models, avoid common pitfalls, and implement reusable calculations. By the end, you’ll be able to create advanced DAX measures and high-performance Power BI solutions for complex analytical requirements.

What you will learn

Understand semantic models and data modeling principles Master DAX evaluation context and context transition Build advanced DAX measures and calculations Use table functions and filtering techniques like TREATAS Implement calculation groups and field parameters Create custom calendars and time intelligence solutions Apply regression and goal-seeking techniques Secure data with attribute-level controls

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.
By:   , ,
Foreword by:  
Imprint:   Packt Publishing Limited
Country of Publication:   United Kingdom
Edition:   2nd Revised edition
Dimensions:   Height: 235mm,  Width: 191mm, 
ISBN:   9781836647638
ISBN 10:   1836647638
Pages:   554
Publication Date:  
Audience:   Professional and scholarly ,  Undergraduate
Format:   Paperback
Publisher's Status:   Active
Table of Contents Analyzing Data with DAX Model Design Using DAX Context and Filtering Security with DAX Dynamically Changing Visualizations Inventory Analysis Alternative Calendars Working with Auto-Exist Recursion in DAX DAX-Driven Waterfalls Benchmarking the Neighbors Real-Estate Investment Planning

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 kinds–with 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.

See Also