Use previous value in further calculation

[adikops]

Hello community,

Need your help with a DAX for the below calculation.

I am trying to use a previous value of a column within a calculation.

An example of this is executed in excel.

I have been going in circles with this calculation for a while now although I have tried a few solutions from the forum.

Your help will be much appreciated. Thanks in advance.

[amitchandak]

@adikops , In power bi we can not use recursive logic, we can not take the previous row of calculations in progress.

Otherwise earlier can help

Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8