Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 |
Solved! Go to Solution.
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! |
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! |
This solved my needs, thank you very much!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 9 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 19 | |
| 17 | |
| 11 |