<!-- https://learnsql.cpetoday.com/functions/dax/year -->
# YEAR

Language: DAX
Category: Date and time
Syntax: YEAR(<date>)
Summary: Returns the four-digit calendar year of a date.
Returns: A whole number, such as 2026.
Level: Beginner
Related: MONTH, DAY, QUARTER, DATE, WEEKNUM

## What it does
YEAR reads the year out of a date. Finance teams use it to label periods, to group amounts by year, and to build a fiscal year label when the fiscal year does not start in January. It is most often used in a calculated column on a Calendar table, so the year is calculated once and reused in every report.

## Syntax and arguments
- date: any date or datetime value, such as a posting date or the Date column of a Calendar table. Required.

## Example
A company has a June 30 year end. Its fiscal year runs from July 1 to June 30, and the fiscal year is named for the calendar year in which it ends. The controller wants a fiscal year label on every date in the Calendar table.

```dax
Fiscal Year =
"FY" & (YEAR('Calendar'[Date]) + IF(MONTH('Calendar'[Date]) >= 7, 1, 0))
```

A date in July 2026 gets FY2027, because it falls in the fiscal year that ends June 30, 2027. A date in June 2027 also gets FY2027. A date in March 2026 gets FY2026. The year is adjusted only for the months from July to December, which are the months that belong to the next fiscal year.

## Example: a second, different use
A calendar column for the calendar year, used as the axis of a trend report or as a sort key.

```dax
Calendar Year = YEAR('Calendar'[Date])
```

## Things to watch
- YEAR returns the calendar year. For a fiscal year that does not start in January, add the adjustment shown above or use a fiscal year column from the Calendar.
- YEAR is a number, not text. Wrap it in FORMAT or concatenate it with "FY" when you need a label.
- Calling YEAR on a blank date returns a blank, not a year, so check for blanks when a date column has gaps.
- For time intelligence, the year boundaries come from the Calendar table, not from YEAR in a measure. Use a date table and functions such as TOTALYTD where possible.

## In business terms
YEAR is the basis for annual reporting: calendar year and fiscal year labels, year-over-year comparisons, annual budgets, and year-end cut-off reviews. Getting the fiscal label right is the first step in any report that compares fiscal years.
