DAX Function Guide

YEAR
Empty image or helper icon

Sam McKay

CEO & Founder

How does the YEAR work?
The YEAR function returns the year of a date in the range 1900-9999 as a four digit integer.
YEAR Formula Syntax

YEAR (
<date>
)

How do you use the YEAR?

Dates should be entered by using the DATE function, or other formula or function results. In accepted text representations of a date like March 3, 2007, or Mar-3-2003, you can also enter dates.

Related Blog Posts

Loading

Considerations when using the YEAR?

If the argument is a string it will be translated into a datetime value using the same rules that the DATEVALUE function applies.

Related Video Tutorials

Loading

Formula examples using the YEAR
=YEAR("March 2007") returns 2007.
=YEAR(DATE (2016,9,15)) returns 2016.
Related Courses

Loading