CURRENT

Family: EVAL and its modifiers

Use it to compare each row with another, such as the month before.

Syntax

1
EVAL(measure, SET(dimension = CURRENT(dimension) - n))

Arguments

Returns

The dimension’s value on the row. It is null when the SELECT neither groups nor filters by the dimension.

Usage notes

• On a date grain, a number counts periods of that grain. On a month, CURRENT(orders.order_month) - 1 is the month before. On a year, - 1 is the year before.
• CURRENT works only inside SET in an EVAL. VALUE_FOR, TOTAL and SHARE_OF_TOTAL take constant values.

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
  MEASURE('units_month_before', EVAL(orders.sum__quantity, SET(orders.order_month = CURRENT(orders.order_month) - 1))) AS "Units the Month Before"
5
FROM kater_dataset.orders AS orders
6
WHERE
7
  KATER__IS_ON_OR_AFTER(orders.order_month, DATE '2026-05-01')
8
GROUP BY
9
  orders.order_month
10
ORDER BY
11
  1

The query starts in May, but May’s row still shows April’s units. SET replaces the filter on the month, so the month before counts.

See also

• Change a measure’s context
• Pass through, evaluate or declare
• Other functions in EVAL and its modifiers: EVAL, CLEAR, REMOVE, SET, SET_CUSTOM