This function will retrieve the month component from the specified datetime value, dateTime.
Syntax
Date.Month(dateTime as any) as nullable number
About
This function will retrieve the month component from the specified datetime value, dateTime.
Explanation
Determine the month in the specified date and time value of December 31, 2011 at 9:15:36 AM using the Power Query function MDate.Month(#datetime(2011, 12, 31, 9, 15, 36)). The output will be the month number, which in this case is 12.