Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cumulative decrease quantity

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's avatar
    Anonymous
    6 years ago

    take look at this solution : 

HotChilli's avatar
HotChilli
Community Champion
6 years ago

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.