This article explains how to avoid circular dependency errors that can occur in DAX when two or more entities (calculated columns or calculated tables) reference one another in such a way that the engine cannot compute their value. Read more
DAX.do is a new website by SQLBI where you can write and run DAX queries over a sample Contoso database. The goal of DAX.do is purely educational: if you are learning DAX or are merely curious to test a new… Read more
When I started publishing YouTube videos, I was eager to read about the setup of other speakers. I was starting from scratch, needing to purchase all the equipment, and I had no idea how to get the most bang for… Read more
In the past few months, we delivered an increasing number of sessions online. It did the job as a replacement for in-person events, but we did not particularly enjoy the lack of interaction among other limitations. We want to provide… Read more
Hierarchies are often created in data models to simplify the browsing of the model by providing users with suggested paths of navigation through attributes The definition of the hierarchies follows the requirements of the model For example the Date table… www.daxpatterns.com
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
Marco Russo
Jun 8-10 - New York City
Jul 19-21 - Sydney
Alberto Ferrari