Averages a column across the previous n rows of a visual's axis. This DAX function exists solely for visual calculations and saves writing the equivalent WINDOW logic.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains MOVINGAVERAGE in context, with comparison tables and the common traps.
Terms in this definition
- PREVIOUS
Fetches the value of the preceding element along an axis of the visual matrix. This DAX function works only in visual calculations and is equivalent to OFFSET with -1.
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- WINDOW
Returns rows from a sorted, optionally partitioned table, either at fixed positions (ABS) or relative to the current row (REL). Running totals plus moving averages are common uses.