# LASTNQTR

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

```javascript
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

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

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F9uQ6U8xCBByQSlLX8jPk%2Fimage.png?alt=media&#x26;token=b5722c4f-41d3-45f2-b9f6-08e7990dd43e" alt=""><figcaption><p>LASTNQTR</p></figcaption></figure>