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
Related distinct count
The Related distinct count pattern is useful whenever you have one or more fact tables related to a dimension and you need to perform the distinct count of column values in a dimension table only considering items related to transactions… 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