Cumulative decrease quantity

[Anonymous]

Hi All,
I want to have the last column decreasing according to the previous one.
Ideally, cumul_col should reach zero in the time slot 23-00.

Any idea?

[Anonymous · Accepted solution]

take look at this solution : 

[HotChilli]

Here's a pattern for a cumulative decreasing amount.  I'm not sure if it is the best answer for your model because you haven't shown the Forecasts table and any relationship between the tables.

RunningTotal = VAR _Hour = TableL[Hour - Start]
               VAR _AddCol = CALCULATE(SUM(TableL[Colissimo]), FILTER(TableL, TableL[Hour - Start] < _Hour)) 
RETURN
    TableL[value] - _AddCol

I split the Hour column so that we have a numeric column to use as a kind of index.  It's just the first number in each Hour field.

Hope it helps.