Forum Discussion
Prasun
2 years agoNew Member
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.
pls try this