Computing open orders with visual calculations in DAX
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 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 is about how to read and use bullet charts when comparing actuals to a target in Power BI, and the different options you have available to make these charts in Power BI reports. 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 pattern describes how to compute month-related calculations such as year-to-date same period last year and percentage growth using a month granularity This pattern does not rely on DAX built-in time intelligence functions You can use the Month-related calculations pattern… More on DAX Patterns
Optimizing DAX is the state-of-the-art book on optimizing DAX expressions in Power BI and Analysis Services semantic models.
Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements. Read more