Forum Discussion
Modifying quick measure YoY%
I tried to modify the quick measure (Year over year change). Original DAX looks like: Taxi Out Time, min YoY% = VAR __PREV_YEAR = CALCULATE(SUM('QAR data'[Taxi Out Time, min]), DATEADD('DATES'[D...
Hi, Anonymous , the issue results from use of variable a in your measure; In fact, variables in DAX are NOT THAT VARIABLE as expected!
In DAX, variables are calculated within the scope in which they are written, and then the result of them is stored and used in the rest of the expression.
You might want to refer to an article on this subject for more details.
A straightforward way is to create a measure a = SUM('QAR data'[Taxi Out Time, min]), and you can reference it in another measure.