Hi,
This might be a bit difficult to explain so I have attached both excel and pbix file, excel contains result column which contains the excel formula.
Basically I have a category column, a date column, starting value column and a value column. Starting value will have value on the first date only and value column will be empty on first date. I need to bring the value from starting value column to next row and subtract the starting value from current value column’s value, then I want to use that result and subtract it from the current value column’s next row value and continue in the next rows.
Please see the excel file’s “Expected Result” column, it might be easier to understand.
mockup.pbix (37.3 KB)
Result.xlsx (9.9 KB)
