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
Range of data.
Example
NEXTNYEAR(2) //Returns data for 2 years after the current one
