The function retrieves the year portion of the datetime value, dateTime.
Syntax
Date.Year(dateTime as any) as nullable number
About
The function retrieves the year portion of the datetime value, dateTime.
Explanation
Determine the year from the information provided: #datetime(2011, 12, 31, 9, 15, 36). This can be achieved by using Power Query MDate.Year(#datetime(2011, 12, 31, 9, 15, 36)), which will result in an output of 2011.