Forum Discussion
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.
Thanks in advance.
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
1 Reply
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