YEARPERIOD

Filters data for a specific year or range of years.

The YEARPERIOD function can be used to select data from a given measure for a particular year or a range of years. It should be used in conjunction with the SELECT clause and with an aggregate function like SUM or AVERAGE.

Syntax

YEARPERIOD(from_year, to_year)

Arguments

from_year – The year for which data has to be fetched or the start year if a range is specified. Required.

to_year - The end year when a range of data has to be fetched. Optional.

Return value

Period Range.

Example

YEARPERIOD(2020,2023) 
//Returns data from 2020 to 2023
YEARPERIOD(2023)
//Returns data from 2023

YEARPERIOD without offset

YEARPERIOD with offset