cummulative prev change
1 Topic
Cummulative Prev Change
Good afternoon I am struggling with a DAX formula, and will appreciate some help Want to create a formula for "Cummulative Prev Change" as per screenshot and following conditions 1) First two rows have to be zero 2) from 3rd row, the formula should get PreviousVersions's "Requested Value" + PreviousVersions's "Cummulative Prev Change" if I tried following formula, to no effect 😞 CummulativePrevChange2 = IF(PA_KEY[Version]>1,LOOKUPVALUE(PA_KEY[RequestedValue],PA_KEY[Version],PA_KEY[Version]-1,PA_KEY[PA#],PA_KEY[PA#]),0) Attached are the sample file and screenshot of how the column should calculate values... PowerBI File How it should look like Thank you in advance for any advise 🙂Solved7.2KViews0likes10Comments