Using weekly calendars in Power BI
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
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
Currency conversion is a complex scenario where both the data model and the quality of the DAX code play an important role There are two kinds of currencies the currency used to collect orders and the currency used to produce… 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