cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Inverse Running Total

I am attempting to calculate an inverse running total on values. So I would in essence start with a value, 100, and in an indexed format reduce that value based on the next indexed field.

Example:

 Index Value Running Difference 1 100 100 2 10 90 3 40 50 4 40 10 5 20 -10
1 ACCEPTED SOLUTION
Community Champion
``````Running Diff =
MINX( FILTER( INFO, INFO[Index] = 1 ), INFO[Value] )
- SUMX(
FILTER( INFO, 1 < INFO[Index] && INFO[Index] <= EARLIER( INFO[Index] ) ),
INFO[Value]
)``````

 Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! DAX is simple, but NOT EASY!
2 REPLIES 2
Community Champion
``````Running Diff =
MINX( FILTER( INFO, INFO[Index] = 1 ), INFO[Value] )
- SUMX(
FILTER( INFO, 1 < INFO[Index] && INFO[Index] <= EARLIER( INFO[Index] ) ),
INFO[Value]
)``````

 Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! DAX is simple, but NOT EASY!
Anonymous
Not applicable

This solved my needs, thank you very much!