A name is important. The right name is important. In this post, I reflect on the choice of names in the Microsoft BI stack. From time to time, a bad name arises. Not a big issue, as together we tend… Read more
This article explains the most common causes of the error, “A circular dependency was detected” in Power BI and Analysis Services. Read more
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
The cumulative total pattern allows you to perform calculations such as running totals You can use it to implement warehouse stock and balance sheet calculations using the original transactions instead of using snapshots of data over time For example in… 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
Alberto Ferrari
Jun 8-10 - New York City
Jul 19-21 - Sydney
Marco Russo