Show Year of Previous to Previous Year from the current selected year

[souvik900766]

Hi ,

I want display the Previous to Previous Year from the current selected year.
For e.g.:-
if my current selected year is 2020 then it should display 2018.
for 1 prior yaer it is working like selectedvalue(year)-1 but If i am doing selectedvalue(year)-2 it is giving the result of PY i.e selectedvalue(year)-1

Thanks in advance !

[VahidDM · Accepted solution]

Hi @souvik900766 

That 

PPY = SELECTEDVALUE('Table (2)'[Year])-2

should work well to find the 2 years before the selected date.

 

 What is the type of your Year column? can you share a sample of your data here (Not a screenshot)?

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!