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 includes several coding techniques you may find useful for budgeting scenarios The techniques do not apply only to budgeting We use the budget as an example to show how to reallocate a measure at a different granularity and… 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