MOVINGAVERAGE
Applies to: Calculated column Calculated table Measure Visual calculation
Returns a moving average calculated along the given axis of the visual matrix. That is, the average of the given column calculated over the last <windowSize> rows.
Syntax
MOVINGAVERAGE ( <column>, <windowSize>[, <includeCurrent>][, <axis>][, <blanks>][, <reset>] )
Parameters
Term  Definition 

column  The column that provides the value for each element. 
windowSize  The number of rows to include in the calculation. Must be a constant value. 
includeCurrent  (Optional) A logical value specifying whether or not to include the current row in the range. Default value is True. 
axis  (Optional) An axis reference, the direction along which the moving average will be calculated. 
blanks  (Optional) An enumeration that defines how to handle blank values when sorting. The supported values are:

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 moving average at the current element of the axis.
Remarks
This function can be used in visual calculations only.
The <includeCurrent>, <axis>, <blanks> and <reset> parameters can be omitted.
Example 1
Given a table that summarizes the total sales for each product category and calendar month, the following DAX query adds a column with the average of total sales for that category in the last 6 months:
AvgSalesLast6Months = MOVINGAVERAGE([SalesAmount], 6, Rows)
The screenshot below shows the visual matrix and the visual calculation expression:
Example 2
Given the same table, the following DAX query adds a column with the average of total sales for that category in the previous 12 months (not including the current month):
AvgSalesPrev12Months = MOVINGAVERAGE([SalesAmount], 12, FALSE, Rows, KEEP)
See also
Feedback
https://aka.ms/ContentUserFeedback.
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:Submit and view feedback for