MOVING_AVERAGE

Family: Calculation context

Syntax

1
MOVING_AVERAGE(value, rows => n) OVER ([PARTITION BY ...] ORDER BY ...)

Arguments

Returns

The average of this row and the rows before it.

Usage notes

• The first rows have fewer rows before them, so their average uses fewer rows.
• Write OVER with ORDER BY after the call. It counts rows, not calendar periods.

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  orders.order_month AS "Order Month",
3
  EVAL(orders.sum__quantity) AS "Units",
4
  MOVING_AVERAGE(orders.sum__quantity, rows => 3) OVER (ORDER BY orders.order_month) AS "Units, 3-Month Average"
5
FROM kater_dataset.orders AS orders
6
WHERE
7
  KATER__IS_ON_OR_AFTER(orders.order_date, DATE '2026-05-01')
8
GROUP BY
9
  orders.order_month
10
ORDER BY
11
  1

See also

• Change a measure’s context
• Other functions in Calculation context: TOTAL, SHARE_OF_TOTAL, VALUE_FOR, CALCULATE_ACROSS, CALCULATE_BY, CALCULATE_PER, RATIO, RUNNING_TOTAL, CUMULATIVE_SHARE, BY, ACROSS, IGNORE_FILTERS