Tag: CALCULATE function

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

DAX Queries Using Variables And Important Functions

DAX Queries Using Variables And Important Functions

This tutorial will discuss about variables, including the FILTER and CALCULATE functions. You’ll understand how these help boost the performance of your DAX queries and provide accurate results. Variables should be used as much as possible because they can easily locate codes for optimization. They prevent you from getting incorrect outputs and save you time

Continue reading

A New Look At CALCULATE – Power BI

A New Look At CALCULATE – Power BI

In this tutorial, we’ll be looking at how to use the DAX function CALCULATE in Power BI. You can watch the full video of this tutorial at the bottom of this blog. CALCULATE is one of the most dynamic functions that can help you add deeper insights to your reports. But to truly understand it,

Continue reading

Time Comparisons In Power BI: This Year vs Last Year

Time Comparisons In Power BI: This Year vs Last Year

I want to go over how you can easily do time comparisons in Power BI and specifically calculate this year versus last year. I’m going to show you a couple of techniques that you can utilize for time comparisons like this. You can watch the full video of this tutorial at the bottom of this

Continue reading

Power BI DAX ALL Function – How It Works

Power-BI-DAX-ALL-Function-–-How-It-Works

I want to give you a really quick introduction to the Power BI DAX ALL function. I find that there can be a bit of confusion around how this function works, and I want to simplify it and make it easy to understand. This tutorial will enable you to recognize where and when you should

Continue reading