What Does 'Variables Are Constants' Really Mean?

Likely whenever you’ve heard an explanation of how to use variables within DAX, you will have heard the phrase “variables are constants”. It seems simple on the face of it, but there’s actually a fair amount of nuance and complexity bundled up in these three words. In this video, I'll walk you through exactly what this phrase means, and the implications for how your measures are calculated. Understanding these concepts is essential to ensuring that your measures produce the desired results.

Brian

***** Video Details *****
00:00 Introduction
02:01 Total sales
03:00 Applying variables
05:45 Common mistaking when using variables
06:22 Iterators
07:05 Using variables to mark current row

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

[luda_c]

Fantastic explanation. Thank you so much!

[christophepassuello]

Very usefull video that lighten a very important concept in DAX, it helps me to understand why some of my measures were not working as intended

[riteshkothari]

Thanks Brian. Great info and your voice is so soothing!

[angietoros]

Help!!!! From today The filter was deconfigured in the drop-down menu selection, that is, when opening the drop-down the position of the filter data appears in another part of the screen and not under the menu, this happens when uploading the report and opening it on the Web. ¿ also happens to them?

[sbn]

I see VAR only as constant but it's more difficult when i start do anything needed.
Can I calculate cumulative with VAR.
For example I have such Table

[Transit] [Day] [Day2]=(needing result)
1. 3 0 1st day= 3-3= 0
2. 5 2 2nd day=3-5= 2
3. 8 5 3d day= 2-8= 5
It means=For first transit it takes 3 day And second transit planed for 5 day and so.... . BUT as first transit takes 3 days I must minus 3days from 2nd transit days (3-5=2). And second transit has 2 days not 5 days because of first transit. I must calculate billon rows with categories and subcategories.