Date.Month

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

Syntax

Date.Month( dateTime as any ) as nullable number

Description

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

Examples

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: https://learn.microsoft.com/en-us/powerquery-m/date-month