MOVINGAVERAGE DAX Function
Calculates a moving average along the specified axis of the Visual Calculation data grid.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Expression |
The expression to be evaluated for each row. |
|
| WindowSize |
The length of the moving window, that is, how many rows will be included. This value should be greater than or equal to 1. |
|
| IncludeCurrent | Optional |
A logical value specifying whether or not to include the current row. If FALSE, the window will contain the last WindowSize values before the current row. Default value is TRUE. |
| 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. |
Last update: Apr 27, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/movingaverage-function-dax