YTD Last year

[Talal141218]

 Hi everyone, 

I want to create a measure to select throgh it YTD for last year and i tryed but as below : 

=calculate( YTD, sameperiodlastyear(date))., but i did't got a result. 

Could you please support me to create a correct m,easure. 

Thanks in advace 

[tamerj1 · Accepted solution]

Hi @Talal141218 

please try

YTD LY =
CALCULATE (
[Measure],
FILTER (
SAMEPERIODLASTYEAR ( 'Date'[Date] ),
VALUE ( FORMAT ( [Date], "mmdd" ) ) <= VALUE ( FORMAT ( TODAY (), "mmdd" ) )
)
)