YEAR
Returns the four-digit calendar year of a date.
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
- 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.
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
- 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.