Accumulates values cumulatively across a visual, by default along ROWS. Available solely within visual calculations, it acts as WINDOW shorthand and may restart per hierarchy level.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains RUNNINGSUM in context, with comparison tables and the common traps.
Terms in this definition
- VALUES
Returns in DAX the distinct column values, or table rows, still visible after filters are applied, sometimes with an extra blank entry. CALCULATE often takes the result as a table filter.
- WINDOW
Returns rows from a sorted, optionally partitioned table, either at fixed positions (ABS) or relative to the current row (REL). Running totals plus moving averages are common uses.
- Hierarchy
Lets report users drill up and down through totals by stacking a dimension's levels in order, for example region, then city, then address, in a semantic model.