countryfan_nt
Well-known Member
- Joined
- May 19, 2004
- Messages
- 753
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!
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!
