Date.Month
The month, 1 to 12, of a date, datetime or datetimezone.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Date.Month(dateTime as any) as nullable number| Parameter | Type | Description |
|---|---|---|
dateTime | any | A date, datetime or datetimezone value; null gives null. |
Returns
nullable number. The month as a number: 1 for January.
Examples
The month of an order
Date.Month(#date(2024, 3, 15))3A month column for a sales table
let
Sales = #table({"Order", "Date"}, {{"A-101", #date(2024, 1, 20)}, {"A-102", #date(2024, 3, 15)}})
in
Table.AddColumn(Sales, "Month", each Date.Month([Date]), Int64.Type)| Order | Date | Month |
|---|---|---|
| A-101 | 2024-01-20 | 1 |
| A-102 | 2024-03-15 | 3 |