# NEXTNYEAR

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.&#x20;

## Syntax

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

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

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FkrRuzIIayRPoa7mnU8ex%2Fimage.png?alt=media&#x26;token=188e1ba1-3c21-44ef-9833-a62b9027d3fd" alt=""><figcaption><p>NEXTNYEAR</p></figcaption></figure>
