Updated on

Date.Month is a Power Query M function that returns the month belonging to the provided date(time) value.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Date.Month( dateTime as any ) as nullable number


Date.Month retrieves the month component from a given dateTime (date, datetime, or datetimezone).


Find the month in #datetime( 2011, 12, 31, 9, 15, 36 ).

// Output: 12
Date.Month( #datetime( 2011, 12, 31, 9, 15, 36 ) )

Learn more about Date.Month in the following articles:

Other functions related to Date.Month are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot
Microsoft documentation: