Chicago, IL, US
Register now

SQLBI+ updates in May 2023

In 2023, we released the first draft of the Window functions in DAX whitepaper as part of SQLBI+. Since then, we have released a few updates and are now glad to announce the availability of the related 3-hour video course…  Read more

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

DAX Patterns

Transition matrix

The Transition matrix pattern analyzes changes in an attribute assigned to an entity at regular intervals For example customers might receive a ranking evaluation every month or products might have a rating score measured every week Measuring the changes in…  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