DAX Capturing the value of last year from a different row.

[countryfan_nt]

Hello friends, Hope all is well!

Please help me adjust and fix the DAX formula.

I want the formula to capture the last year results. i.e. take the year of the existing row and Minus -1.

=CALCULATE(sum(fndb[value]), FILTER( fndb, fndb[year]=earlier(FNDB[year])&&fndb[branch]=earlier(FNDB[branch])&&fndb[#]="13") )

Thank you very much in advance!