Calculate the variance with the last value of the previous year

[PBI_37]

Hi everyone,

I need your help to calculate the variance with the last value of the previous year.

Expected result :

Here is the link of the PBI file : 

https://drive.google.com/file/d/1kSY2MDKMvnRlUDlK03T87FBxDDYTwxeJ/view?usp=sharing

Thank you

[PBI_37]

Thank you @Ahmedx 

I added data for 2021 but the last December 2021 value is not on 2022 rows.

[Ahmedx · Accepted solution]

pls try

if something is wrong, give me the updated file

[PBI_37]

It works fine.

Thank you

[Ahmedx]

pls try this