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

Semi-additive calculations

Calculations reporting values at the start or the end of a time period are quite the challenge for any BI developer and DAX is no exception These measures are not hard to compute the complicated part is understanding the desired…  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