topic Re: Show Year of Previous to Previous Year from the current selected year in DAX Commands and Tips

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

souvik900766 — Thu, 02 Sep 2021 07:47:17 GMT

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 !

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

VahidDM — Thu, 02 Sep 2021 08:12:20 GMT

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 !!