Return data from specified time interval in all rows in a calculated column

[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.

Thanks in advance !

[Tanushree_Kapse]

Hi @souvik900766 ,

Try using this:
2018data(measure)= CALCULATE(SUM(CY), PARALLELPERIOD(Month, -3, Year))


I believe this is what you want.

[souvik900766]

Hi @Tanushree_Kapse 
Its not working !

A circular dependency was arising so i used the formula this way.

[Tanushree_Kapse]

Hi @souvik900766 ,
You want to show 2018 data in 2018 column at all times ... irrespective of the months in the Month column?
If this is what you need, the try using ALL instead of ALLEXCEPT.

[souvik900766]

Hi @Tanushree_Kapse 
Yes you are right, thats what I want,
Its not working
I tried with this options

Thanks