London, England, GBIntroducing calendar-based time intelligence in DAX
Marco Russo & Alberto FerrariThis article introduces the new calendar-based time intelligence functions in DAX, available in preview from the September 2025 release of Power BI. Read more
Introducing user-defined functions in DAX
User-defined functions are a new and exciting feature in DAX. In this article, we outline the key concepts to understand before using them in Power BI projects. Read more
Dec 2-4 - Amsterdam
Oct 28-30 - Lugano
Nov 12-14 - Chicago
Video Training
Introducing DAX Video CourseFree
Introducing AI and agentic development for Power BI
Kurt BuhlerThis article is about useful concepts and scenarios for integrating AI and AI agents in BI development, with specific examples for Power BI. Read more
AI workflows and agentic development for Power BI: An initial review
Overview of the various capabilities of AI workflows and agentic development for Power BI. The focus is on AI for BI professionals, not conversational BI for data consumers. Read more
DAX Patterns
Related distinct count
The Related distinct count pattern is useful whenever you have one or more fact tables related to a dimension and you need to perform the distinct count of column values in a dimension table only considering items related to transactions… 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