last to last year sales

[manishsalanke]

hi everyone i have an issue ,i want calculate sales for last to last year

and last year sales

we have created a current year sales

 we have created currunt year(2022) sales and last years(2021) sale now we want to show last to last year(2020) sale .need some suggestions.

[FreemanZ]

hi @manishsalanke

try like:

Last Last Year Sales =

CALCUALTE(

    [CY Sales Lacs],

    DATEADD(Calendar[Date], -2, YEAR)

)