NEXTNQTR

The NEXTNQTR function can be used to select data from a given measure, for a specified number of quarters after the current quarter. It should be used with the SELECT clause and an aggregate function like SUM or AVERAGE.

Syntax#

NEXTNQTR(number_of_quarters)

Arguments#

number_of_quarters – The number of quarters for which data has to be fetched. Required.

Return value#

Range of data.

Example#

NEXTNQTR(6) 
//Returns data for 6 quarters after the current quarter