RUNNINGSUM DAX Function (Visual calculations)
Calculates a running sum along the specified axis of the Visual Calculation data grid.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Expression |
The expression to be evaluated for each row. |
|
| Axis | Optional |
An axis reference. |
| Blanks | Optional |
An enumeration that defines how BLANK values are ordered. Valid values are: DEFAULT, LAST, FIRST. |
| Reset | Optional |
Specifies how the calculation restarts. Valid values are: None, LowestParent, HighestParent, or an integer. |
Notes
The visual calculation functions have an axis parameter that is defined in the VISUAL SHAPE query syntax produced by the visual calculation feature in Power BI.
Related articles
Learn more about RUNNINGSUM in the following articles:
-
Computing open orders with visual calculations in DAX
This article describes the use of visual calculations for a scenario where they may be particularly relevant: computing open orders at the end of a time period. » Read more
Last update: Dec 16, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/runningsum-function-dax