CURRENT_PERIOD

The CURRENT_PERIOD identifier dynamically refers to each period in the report. It can be used with date-based functions like SHIFT or MOVING_AVERAGE.

Example

1. The AGGREGATE function has been used with the CURRENT_PERIOD identifier to find the minimum sales 3 months prior to each month in the report.

AGGREGATE with CURRENT_PERIOD

1. We've used SHIFT function with the CURRENT_PERIOD identifier to shift each month by 2 months. For example, for January, the SHIFT function returns March 01st.

SHIFT function with CURRENT_PERIOD

1. We've used MOVINGSUM with the CURRENT_PERIOD identifier to calculate the rolling sum of the profit for each month and 2 months after that month. For example, the MOVINGSUM for January would be the sum of the profits for January, February, and March.

MOVINGSUM with CURRENT_PERIOD