Return data from specified time interval in all rows in a calculated column
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 three but not working..