Populating rows of the same column with the previous row value

[Mohana_Mondal]

In Power BI how will I populate the following row values of the same column based on the previous row value?

I have an excel that looks like this with columns : Day, Volume, Current Demand, Future Demand and Current Storage.Excel Table

Formula

I want to populate the column 'Current Storage' in PowerBI with the formula same as the above excel formula. Is it possible to do this?

Any suggestion and help is very much appreciated.

[v-yadongf-msft]

Hi @Mohana_Mondal ,

It is recommended to complete the calculation of the above formula in excel. It will become very complicated to achieve the same calculation as excel in Power BI.

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.