article –
Avoiding circular dependency errors in DAX
This article explains the most common causes of the error, “A circular dependency was detected” in Power BI and Analysis Services. Read more
article –
Understanding Circular Dependencies in DAX
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
Jun 8-10 - New York City
Jul 19-21 - Sydney
Video Training
Introducing DAX Video CourseFree
blog post –
Introducing DAX.do
Marco RussoDAX.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
article –
Letter case-sensitivity in DAX, Power BI and Analysis Services
Power BI and Analysis Services are case-insensitive by default.Lowercase letters are identical to uppercase letters.This is mostly a good choice, but it also comes with unexpected consequences. In this article, we run through a set of queries to understand what… Read more
DAX Patterns
Currency conversion
Currency conversion is a complex scenario where both the data model and the quality of the DAX code play an important role There are two kinds of currencies the currency used to collect orders and the currency used to produce… www.daxpatterns.com
Book –
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