Toronto, ON, CAAI in Power BI: Time to pay attention
Kurt BuhlerThis article is about the state of AI tools with Power BI, and how to use the model context protocol (or MCP) to interact with and control Power BI or Fabric with a large language model (or LLM). Read more
A few thoughts about newsletter #300 and AI
Marco RussoNewsletter #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
Dec 2-4 - Amsterdam
Oct 1-3 - London
Oct 28-30 - Lugano
Video Training
Introducing DAX Video CourseFree
ALLSELECTED best practices
Marco Russo & Alberto FerrariALLSELECTED is a powerful, yet dangerous function. This article describes the best practices to follow to avoid falling into the pitfalls involved with ALLSELECTED. Read more
Choosing between DISTINCT and VALUES in DAX
When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model changes. Read more
DAX Patterns
Comparing different time periods
This pattern is a useful technique to compare the value of a measure in different time periods For example we can compare the sales of the last month against a user-defined period The two time periods might have a different… 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