YTD for next year ignores slicer

[Pikachu-Power]

Hi all,

i have on the canvas a YEAR and MONTH Slicer and the following two measures which i compare: 

Plan_YTD = TOTALYTD([Plan], Calender[Date])

Plan_YTD_NY = CALCULATE([Plan_YTD], NEXTYEAR(Calender[Date]))

Plan_YTD is how I want... when I choose YEAR = 2022 and MONTH = 6 i see the cumulated value from MONTH 1 until 6 for YEAR 2022.  But the Plan_YTD_NY doesnt react to the month slicer. It always shows YTD for the whole year 2023.

Someone an idea why Plan_YTD_NY ignore my month slicer? 😕

[Cado_one · Accepted solution]

Hi @Pikachu-Power 
The NEXTYEAR function always returns a full year of dates.

You can try instead :

Plan_YTD_NY = CALCULATE([Plan_YTD], PARALLELPERIOD(Calender[Date], 1, YEAR))

Have a good day,

Cado

[Pikachu-Power]

Ok Thank you! PARALLELPERIOD with "12 MONTH" instead of "1 YEAR" helps.