RUNNINGSUM
Applies to: 
Calculated column
Calculated table
Measure 
Visual calculation
Returns a running sum calculated along the given axis of the visual matrix. That is, the sum of the given column calculated over all rows up to the current row.
Syntax
RUNNINGSUM ( <column>[, <axis>][, <blanks>][, <reset>] )
Parameters
| Term | Definition |
|---|---|
| column | The column that provides the value for each row. |
| axis | (Optional) An axis reference, the direction along which the running sum will be calculated. |
| blanks | (Optional) An enumeration that defines how to handle blank values when sorting. This parameter is reserved for future use. |
| reset | (Optional) Indicates if the calculation resets, and at which level of the visual shape's column hierarchy. Accepted values are: NONE, LOWESTPARENT, HIGHESTPARENT, or an integer. The behavior depends on the integer sign: - If zero or omitted, the calculation does not reset. Equivalent to NONE. - If positive, the integer identifies the column starting from the highest, independent of grain. HIGHESTPARENT is equivalent to 1. - If negative, the integer identifies the column starting from the lowest, relative to the current grain. LOWESTPARENT is equivalent to -1. |
Return value
A scalar value, the running sum up to the current row.
Remarks
This function can be used in visual calculations only.
The <axis>, <blanks> and <reset> parameters can be omitted.
Example
Given a table that summarizes the total sales for each product category and calendar year, the following DAX query adds a column with the total sales for that category up to a given year.
SalesUpToDate = RUNNINGSUM([SalesAmount], Rows)
The screenshot below shows the visual matrix and the visual calculation expression:
See also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for