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 : 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.