Forum Discussion
Return current year only
Hello all,
can you please help me... I want to display the average value for the current year on the Card.
It is working like this for the last month and I want something similar for the current year:
It is working like this for the last month and I want something similar for the current year:
MTD = CALCULATE(AVERAGE(TARGETS_L4_KPI_PLANT[Target]),
DATESINPERIOD('Calendar'[Date],
MAX('Calendar'[Date]),
-1,
MONTH))
Thank you
Michael
1 Reply
Hi Michael92 , you can use the built-in TOTALYTD function for that.
