Downloads
Power Query MDateBeginner

Date.MonthName

Returns the name of the month of a date, such as "October".

Syntax
Date.MonthName(dateTime as any, optional culture as nullable text) as nullable text

Returns: The month name as text, or null when the input is null.

What it does

Date.MonthName gives the name of the month, such as "October", for a column heading or a chart label. The name is in the language of the culture you pass. Names sort alphabetically, not in calendar order, so keep the month number for sorting and use the name only for display.

Syntax and arguments

Example

A board report needs a label such as "October 2026" for each reporting month. The month name is built from the date and joined with the year.

let
    Period = #date(2026, 10, 29),
    Label = Date.MonthName(Period, "en-US") & " " & Text.From(Date.Year(Period)),
    ShortLabel = Date.ToText(Period, "MMM yyyy", "en-US")
in
    {Label, ShortLabel}

Label is "October 2026" and ShortLabel is "Oct 2026". The two forms use the same date, one spelled out and one abbreviated, which is a choice of style for the report.

Example: a second, different use

Use the month name in a title for a monthly variance file, with the culture set so the name is the same on every machine.

Things to watch

In business terms

Management reports, board packs and investor letters label each month. Consistent month names with the year make a multi-year trend easy to read, while the number underneath keeps the rows in the right order.

Related functions

All Power Query M functions · View as Markdown · M basics