-
This article describes when to use VALUES in a table grouped by SUMMARIZE, then goes on to explain why you cannot however use VALUES with SUMMARIZECOLUMNS. Read more
-
Value filter behavior is a setting in Power BI semantic models that controls how filters are combined in SUMMARIZECOLUMNS. This article explains how it works and suggests its best configuration. Read more
-
This article introduces the new calendar-based time intelligence functions in DAX, available in preview from the September 2025 release of Power BI. Read more
-
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
-
This article is about useful concepts and scenarios for integrating AI and AI agents in BI development, with specific examples for Power BI. Read more
-
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
-
Why and when you should use VALUES while iterating a table reference in DAX. Read more
-
This article describes the sideways recursion triggered by invoking a calculation item from another calculation item, explaining why it should be avoided to steer clear of unexpected results. Read more
-
SUMMARIZECOLUMNS is a powerful and complex function in DAX that in 2025 can be used in measures. This article outlines the best practices when using this function to avoid incorrect results. Read more
-
For many years, SUMMARIZECOLUMNS has been a function dedicated to DAX queries and calculated tables, but it was not supported in DAX measures. Over time, Microsoft lifted the limitations, and in June 2024, the function was declared as fully supported… Read more