Topic: DAX

        423 posts
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

blog post –

Introducing DAX.do

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

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

blog post –

What has happened in the DAX world in 2020

At the end of a year marked by the pandemic, it is time for our usual review of what happened in the DAX realm. The enthusiasm we typically demonstrate in this traditional end-of -year post is tainted this year by…  Read more