Topic: Power BI
-
This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code easier to read and maintain. Read more
-
This article shows how to build a basic date table using a calculated table and DAX. Read more
-
This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates. Read more
-
This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results when using the same operations in other languages. Read more
-
This article shows how to improve line charts with a date-based X-Axis in Power BI using DAX, and how to make correct choices in the data modeling and visualization properties. Read more
-
This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ties. Read more
-
This article describes the behavior of auto-exist in DAX, explaining the side effects of combining slicers on columns of the same table in Power BI. Read more
-
This article describes how to use a measure to filter a Power BI visualization, and the different behaviors of a same filter between different visuals. Read more
-
This article describes how to optimize DAX expressions with mutually exclusive calculations that might cause slow query performance. Read more
-
This article describes the behavior of the COMBINEVALUES function in DAX, and how it can optimize the performance of DirectQuery with multi-column relationships. Read more