Return current year only

[Michael92]

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:

MTD = CALCULATE(AVERAGE(TARGETS_L4_KPI_PLANT[Target]),

DATESINPERIOD('Calendar'[Date],

MAX('Calendar'[Date]),

-1,

MONTH))

Thank you

Michael

[Smalfly]

Hi @Michael92 , you can use the built-in TOTALYTD function for that.