12 months prior return

[D_HL]

Hi All, 

May have been answered previously but I'm struggling to locate. I'm trying to create a new measure which will bring what another measure was 12 months ago. Table below, the red column is what I want to acheive. 

Date	Customer Name	Current Rating	Rating 12mths prev
1/1/2020	ABC	3	N/A
1/1/2021	ABC	8	3
1/1/2022	ABC	9	8
1/1/2023	ABC	2	9

Thanks

Dan 

[JoeBarry · Accepted solution]

Hi @D_HL 

Please try

Rating 12 months Previously = CALCULATE(SUM('Table'[Rating]), DATEADD('Table'[Date], -1, YEAR))

Thanks

Joe

If this post helps, then please Accept it as the solution