YTD amount for 2 or 3 years ago

[admin_xlsior]

Hi how to create measure for YTD years ago (2 or 3 years ago) ?

If lets say I have this data ->

I tried to write 2 measures but both are returning wrong value:

Actual GP YTD = CALCULATE(SUM('WO'[Actual GP]), DATESYTD('WO Date'[Date]))

Actual GP YTD 2 = TOTALYTD(SUM('WO'[Actual GP]), 'WO Date'[Date])

Aren't this measure should return value start from January, month by month gradualy like running total ?

Kindly help

Thanks,

[v-chuncz-msft · Accepted solution]

@admin_xlsior ,

For any time intelligence function, you could implement a custom DAX formula.

https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/