Topic: Power BI
-
This article describes what limited relationships are and the differences between regular and limited relationship in Power BI and DAX. 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
-
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
-
Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance and scalability than DirectQuery at the price of a small development cost. Read more
-
This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services. Read more
-
The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. Read more
-
This article describes how the SELECTEDVALUE DAX function simplifies the syntax required in many scenarios where you need to read a single value selected in the filter context. Read more