cancel
Showing results for
Did you mean:
Helper IV

## DAX for Cumulative subtraction

I have two columns

 Value Total 10 600 20 600 40 600 30 600 10 600 80 600 20 600 40 600

Expected output is

 Output 590 570 530 500 490 410 390 350

Please suggest a DAX formula to perform this action.

1 ACCEPTED SOLUTION
Community Champion

1. From your table display choose Edit Query

2. When the Query Editor Opens up choose AddColumn tab and Index Column from 0

3. Create RunTot columns as

RunTot = CALCULATE(sum(Table1[Value]), FIlter(Table1,Table1[Index]<=EARLIER(Table1[Index])))

( replace Table1 by the name of your table )

4. Create another column Final

Final = [Total]-[RunTot]

5. Plot the values in a Table Chart and you will get the desired output.

If this works for you please accept this as a solution and also give KUDOS.

Cheers

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Community Champion

1. From your table display choose Edit Query

2. When the Query Editor Opens up choose AddColumn tab and Index Column from 0

3. Create RunTot columns as

RunTot = CALCULATE(sum(Table1[Value]), FIlter(Table1,Table1[Index]<=EARLIER(Table1[Index])))

( replace Table1 by the name of your table )

4. Create another column Final

Final = [Total]-[RunTot]

5. Plot the values in a Table Chart and you will get the desired output.

If this works for you please accept this as a solution and also give KUDOS.

Cheers

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Announcements