Copenhagen, DKStrings list to table in DAX
Marco RussoDAX is not like M when it comes to data manipulation, and it is not supposed to do that. However, if you need something in DAX similar to Table.FromList in M, this blog post is for you. If you have… Read more
SQLBI video course services for enterprise
This article describes all the options and APIs available to improve the use of SQLBI video courses in an enterprise environment. Read more
May 27 - Amsterdam
Aug 9 - Melbourne
Sep 23-25 - Vancouver
Jun 25-27 - Chicago
Video Training
Introducing DAX Video CourseFree
Best practices for using KEEPFILTERS in DAX
Marco Russo & Alberto FerrariThis article describes the best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Read more
The Optimizing DAX book is available
We are proud to announce the availability of our new book, Optimizing DAX. Read more
DAX Patterns
Month-related calculations
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
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