Downloads
DAXDate and timeBeginner

YEAR

Returns the four-digit calendar year of a date.

Syntax
YEAR(<date>)

Returns: A whole number, such as 2026.

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

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.

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.

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

Things to watch

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.

Related functions

All DAX functions · View as Markdown · DAX fundamentals