Copenhagen, DKUnderstanding apply semantics for window functions in DAX
Marco Russo & Alberto FerrariThis article explains the unique behavior of apply semantics: a new way of computing table expressions when multiple rows are selected in DAX window functions. Read more
DAX classes in Australia – August 2024
Marco RussoI am glad to be back in Australia in August 2024: we planned three Mastering DAX classes and two SQLBI Days about DAX Optimization. Read more
May 27 - Amsterdam
Aug 9 - Melbourne
Sep 23-25 - Vancouver
Jun 25-27 - Chicago
Video Training
Introducing DAX Video CourseFree
Strings list to table in DAX
DAX 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
DAX Patterns
Events in progress
The Events in Progress pattern has a broad field of application It is useful whenever dealing with events with a duration - events that have a start date and an end date The event is considered to be in progress… 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