NEXTNYEAR

Filters a range of data for 'n' years after the current date.

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

Syntax

NEXTNYEAR (number_of_quartersyears)

Arguments

number_of_years – The number of years for which data has to be fetched. Required.

Return value

Period Range.

Example

NEXTNYEAR(2) 
//Returns data for 2 years after the current one

NEXTNYEAR