The PERIOD_RANGE function returns an array of dates between two specified dates. This function is commonly used with functions such as FILTER to evaluate and analyze data within a specific date range.
Syntax
PERIOD_RANGE(fromDate,toDate)
Arguments
fromDate: The start date of the range.
toDate: The end date of the range.
Return value
Returns an array of dates within the specified range.
Example
PERIOD_RANGE(DATE(2023,1,1),DATE(2023,12,31))
Creates a date range for all dates in the year 2023.
Usage with forecasts
The PERIOD_RANGE function can be used with forecast data to analyze values within open forecast periods. In this scenario:
PERIOD_RANGE selects the open forecast periods.
FILTER returns forecast values greater than 1000 within those periods.
An aggregate function such as SUM calculates the total of the filtered forecast values.
