Topic: DAX
-
Visual calculations are useful for performing calculations specific to a visual. Conditional formatting is a great example of this concept. In this article, we show how to easily implement conditional formatting through visual calculations. Read more
-
This article describes an Accounts Receivable Aging report in Power BI, and shows how to simplify a business problem using existing modeling patterns. Read more
-
This article describes the differences between the ALL and CROSSFILTERED functions in DAX. Read more
-
This article describes how to optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. Read more
-
This article explores the implications of having blank values in date columns and provides the best practices for managing them in DAX calculations and Power BI reports. Read more
-
This article describes the use of visual calculations for a scenario where they may be particularly relevant: computing open orders at the end of a time period. Read more
-
This article describes why week-based calendars (like 4-4-5) are important for specific industries and how to use them effectively in Power BI. Read more
-
The choice of data types can affect precision and performance because of internal conversions. This article shows how the right choice of data type and DAX code makes a significant difference. Read more
-
This article is about creating dynamic images in DAX measures to visualize data in tables or cards, including an easy way to do this in Figma, and a caution for using these DAX measures in real-life scenarios. Read more
-
This article describes the DAX context transition using a conceptual model based on a visual representation. Read more