Toronto, ON, CA
Register now

A few thoughts about newsletter #300 and AI

Newsletter #300 is a significant milestone for SQLBI: it marks nearly 12 years of sending our updates every two weeks. I thought this was a good time to clarify SQLBI’s position on a topic we haven’t discussed much yet: Artificial…  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