Development tools for Tabular models in 2021
Marco RussoThis article is the state-of-the-art guide of the development tools for Power BI and Analysis Services models, providing guidance to improve productivity and access to new features. Read more
When to use KEEPFILTERS over iterators
Marco Russo & Alberto FerrariThis article describes how to use KEEPFILTERS in DAX iterator functions to preserve arbitrarily shaped filters in context transition. Read more
Jul 19-21 - Sydney
Oct 13-15 - New York City
Video Training
Introducing DAX Video CourseFree
Power BI – Star schema or single table
This article analyzes a classic modeling question: is it better to build a model as a regular star schema or as a single table in Power BI? The answer is clear: a star schema is always the best choice. Read more
Common mistakes in big data models – Live Event
Don’t miss the upcoming free SQLBI live event on Friday April 16, 2021! Join Adam Saxton, Alberto Ferrari, Patrick LeBlanc, and Marco Russo to discuss common mistakes in big data models. Proper data modeling will be a hot topic in… Read more
DAX Patterns
Dynamic segmentation
The Dynamic segmentation pattern is useful to perform the classification of entities based on measures A typical example is to cluster customers based on spending volume The clustering is dynamic so that the categorization considers the filters active in the… More on DAX Patterns
SQLBI Corp.
DAX Patterns, Second Edition
A pattern is a general, reusable solution to a frequent or common challenge.
This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more