topic Substract from previous row and keep it in same column in Developer

Substract from previous row and keep it in same column

Anonymous — Tue, 30 Mar 2021 05:11:20 GMT

Hi I have question how to substract from previous row and input it in current row and for the 1st row we have 1,000,000 as starting value

Thank

Re: Substract from previous row and keep it in same column

lbendlin — Wed, 31 Mar 2021 00:35:14 GMT

Use the List.Accumulate function. You need some sort of an index column that makes each row unique and sortable.

Re: Substract from previous row and keep it in same column

Anonymous — Fri, 02 Apr 2021 01:13:34 GMT

Hi Anonymous ,

You can create two measures as below to achieve it:

FORECAST REDUCER = SUM('Table'[PRODUCTIVITY])*SUM('Table'[PEOPLE])*30

FORECAST = VAR _tab = SUMMARIZE ( 'Table', 'Table'[DATE], "Forecast", 1000000 - SUMX ( FILTER ( ALL ( 'Table' ), 'Table'[DATE] <= SELECTEDVALUE ( 'Table'[DATE] ) ), [FORECAST REDUCER] ) ) RETURN SUMX ( _tab, [Forecast] )

Best Regards