Forum Discussion
DAX for Cumulative subtraction
- Anonymous9 years ago
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. 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