YEAR DAX Function
The function returns the year of a date as a four-digit integer in the range 1900-9999.
DAX Syntax YEAR(date)
The parameter date is a date in datetime format, or a text representation of a date.
Example: Create a Calculated Column.
DAX
Year Column = YEAR('Sheet1'[Date of Birth])
