LASTNQTR

Filters a range of data from the last 'n' quarters prior to the current quarter.

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

Syntax

LASTNQTR(number_of_quarters)

Arguments

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

Return value

Period Range.

Example

LASTNQTR(6) 
//Returns data from the past 6 quarters preceding the start of the current quarter

LASTNQTR