I need to forecast values by date by picking last provider value and subtract from a constant and generate series by subtracting from previous row value - constant until the value equals to 0.
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
