topic Cumulative decrease quantity in DAX Commands and Tips

Cumulative decrease quantity

Anonymous — Wed, 19 Feb 2020 10:18:29 GMT

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?

Re: Cumulative decrease quantity

HotChilli — Wed, 19 Feb 2020 14:46:36 GMT

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.

Re: Cumulative decrease quantity

Anonymous — Wed, 19 Feb 2020 14:47:59 GMT

take look at this solution :