How calcul Year N-1 in case N and N-2 in N-1

[Cobra77]

Hi ,

With this sample :

How to trace the data of a line ?

We only want details over 2 years, and a column indicating that it's for year n-1

Thanks for your helps

[amitchandak]

Last year/last year full should work for your need

last Year Sales full = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOYEAR(dateadd('Date'[Date Filer],-1,year))))
last to Last Year Sales full = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOYEAR(dateadd('Date'[Date Filer],-1,year))))


Last Year  = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date Filer]))
Last to last Year = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR(DATEADD('Date'[Date Filer],-1,year)))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Cobra77]

hi @amitchandak 

If i dont have Date Table

if my facts are related to a version table whose calculation depends on a selected version in a view unrelated to the fact

is it possible ?

Thanks

[amitchandak]

If possible please share a sample pbix file after removing sensitive information.
Thanks