Copenhagen, DKComputing open orders with visual calculations in DAX
Marco Russo & Alberto FerrariThis 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
Building bullet charts in Power BI reports
Kurt BuhlerThis 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
Dec 10-12 - Amsterdam
Feb 18-20 - Phoenix
Video Training
Introducing DAX Video CourseFree
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
Impact of data types in DAX arithmetical calculations
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
DAX Patterns
Week-related calculations
This pattern describes how to compute week-related calculations such as year-to-date same period last year and percentage growth using a week granularity This pattern does not rely on DAX built-in time intelligence functions All the measures refer to the fiscal… More on DAX Patterns
SQLBI Corp.
Optimizing DAX, Second Edition
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