Return the value of specified date based on max date

[souvik900766]

Hi !

My Data:-

Year	Month	CY	2018
2019	Jan,19	784003.6
2020	Jan,20	796923
2021	Jan,21	912686.3
2018	Jan,18	754578.3

I want to return year 2018 CY Value i.e. 754578 in 2018 Column in all rows.
The calculation should be based on latest month for e.g.
MAX(Month),dateadd(month,-3,year)
So, here I want to find from Jan, 2021, to 3 years prior data.
I tried with this formula:-

Thanks in advance !

[daxer-almighty]

Have I not already answered this very question in another post? I think I have. Why don't you use what I've given you?