RUNNINGSUM

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:

DAX visual calculation

See also

INDEX
MOVINGAVERAGE
ORDERBY
PARTITIONBY
WINDOW