# YEARPERIOD

The **YEARPERIOD** function can be used to select data from a given measure for a particular year or a range of years. It should be used in conjunction with the SELECT clause and with an aggregate function like SUM or AVERAGE.&#x20;

## Syntax

```javascript
YEARPERIOD(from_year, to_year)
```

## Arguments

from\_year – The year for which data has to be fetched or the start year if a range is specified. Required.

to\_year - The end year when a range of data has to be fetched. Optional.

## Return value

Period Range.

## Example

```javascript
YEARPERIOD(2020,2023) 
//Returns data from 2020 to 2023
YEARPERIOD(2023)
//Returns data from 2023
```

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F6MaI0IUwzl5xcmSm8HSa%2Fimage.png?alt=media&#x26;token=064f5afb-48a8-4e2b-aace-597afd88bb11" alt=""><figcaption><p>YEARPERIOD without offset</p></figcaption></figure>

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F5jkDuSM7ZNCCgvk3lAB6%2Fimage.png?alt=media&#x26;token=88045060-a857-48e4-9348-4f2ad1d51440" alt=""><figcaption><p>YEARPERIOD with offset</p></figcaption></figure>
