Date.MonthName
Returns the name of the month of a date, such as "October".
Date.MonthName(dateTime as any, optional culture as nullable text) as nullable textReturns: 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
- dateTime: a date or a datetime value.
- culture (optional): the culture for the name, such as "en-US" for English or "fr-FR" for French. Leave it out for the machine's culture.
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
- Pass a culture for names in another language, so the report is consistent.
- Names sort in alphabetical order. Sort by the month number and hide it, or the year will be out of order.
- A month name does not include the year, so add the year whenever the report spans more than one year.
- Null in gives null out.
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.