YEARPERIOD
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
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
Range of data.
Example
Last updated
