Forum Discussion

Bebs's avatar
Bebs
Icon for Helper II rankHelper II
4 years ago

Dynamic measure label

Hi, I've a newbie question 😅 :

I've several measures like this (using a year in "parameter")

EXPENSES_MAX=CALCULATE(measures[EXPENSES], FILTER(data,data[YEAR]=global_VARIABLES[YEAR_N])

YEAR_N = MAX(data[YEAR]).

 

Is there a way to change dynamically the displayed name of the measure in report ? (instead of displaying EXPENSES_MAX, i'd like to display 2022 ; I know how to change it manually in a table but next year I'll need to change manually everywhere so I'd like to do it dynamically).

 

Regards