Topic: DAX
-
This article describes what limited relationships are and the differences between regular and limited relationship in Power BI and DAX. Read more
-
Using variables in DAX makes the code easier to read, faster, and easier to debug. In this article, we discuss how and when to use variables, along with why they are so important in any DAX expression. Read more
-
DAX introduced a GROUPBY function that should replace SUMMARIZE in some scenarios. This article describes how to use GROUPBY in nested grouping scenarios and other improvements. Read more
-
This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI. Read more
-
This article explains how to improve DAX queries using GENERATE and ROW instead of ADDCOLUMNS when you create table expressions. Read more
-
Rolling averages are a very common calculation used to smooth out charts. This article shows how to compute a rolling average taking into account only the working days. Read more
-
Using variables in DAX makes the code easier to read, faster, and easier to debug. Learn how and when to use variables, along with why they are so important in any DAX expression. Watch now
-
The Whiteboard is a new series on the SQLBI YouTube channel where I use a whiteboard to describe abstract DAX and Tabular concepts in a more interactive way. I usually represent these concepts by drawing on a whiteboard in our… Read more
-
This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or FILTER. Read more
-
Learn what the row context is in DAX with a more graphical explanation! Watch now
