Forum Discussion

Prasun's avatar
Prasun
New Member
2 years ago
Solved

Run Down Formula in Power Query refering to previous row's values

I'm trying to run down formula in Power Query refering to previous row's values.

In this dataset, where value of Stock is null, the value should be  Stock = Previous day's Stock - Previous day's ConsumptionPerDay

for 05/06/2024.... it should be 1300 - 100 = 1200; similarly for the next day it should be 1200-100 = 1100 & so on till the last row.