Date.MonthName
Date function · By Tahir Nas · Examples run in our simulator · Published · Updated
Returns the month name for a date.
When to use it
Use it for readable month labels in reports and date tables. Pair it with a month number column for sorting, because names sort alphabetically, and pass a culture so the labels don't change with the machine that refreshes.
Syntax
Date.MonthName(date as any, optional culture as nullable text) as nullable textParameters
- culture
- Language of the name, e.g. "en-US".
Returns
The month name.
Example
Date.MonthName(#date(2026, 3, 9), "en-US")Result
March
Example: month name in another language
The culture decides the language of the name.
Date.MonthName(#date(2026, 3, 9), "de-DE")Result
März
Both results are produced by the Power Query Exercises simulator, an independent implementation of a documented subset of M, and checked on every build.
Good to know
- Pass a culture so names don't depend on the machine.
Common mistakes
- Sorting by the name column (April before January).
- Leaving the culture out, so names change with the machine.
Exercises that use Date.MonthName
Learn more
- Date parts and durations lesson
- Build a date table in Power Query guide
- Power Query date functions cheat sheet (tested) guide
Related functions
Official documentation: Date.MonthName on Microsoft Learn.