Tag: context transition

Iterators and Context Transitions In DAX Queries

Iterators and Context Transitions In DAX Queries

This tutorial will discuss context transition and nested Iterators. You’ll learn the importance of these entities and how they can be a good source for optimization. If you recall, context transition happens when a row context changes into an equivalent filter context. You need to be aware of what’s happening when a context transition occurs

Continue reading

Power BI Filters: Invoking Context Transitions

Power BI Filters: Invoking Context Transitions

This tutorial will discuss about Power BI filters. You’ll learn how to see context transition in the xmSQL and the logical query plan. The context transition transforms the current row context into an equivalent filter context. The filters are then triggered by the CALCULATE function. The Importance Of The CALCULATE Function The CALCULATE function creates

Continue reading

Introduction to Filter Context in Power BI

Filter context is one of the major topics that any Power BI user should initially learn about, especially if you want your DAX calculations to work effectively. You may watch the full video of this tutorial at the bottom of this blog. In this article, I will run through the filter context. Every DAX formula

Continue reading

How To Use The EARLIER Function In Power BI – A DAX Tutorial

Most DAX beginners and even intermediate users really struggle in understanding what the EARLIER function does. It also took me a long time to understand how, when and why you should use this function in Power BI. You may watch the full video of this tutorial at the bottom of this blog. In this article, we

Continue reading