Power QueryExercises

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 text

Parameters

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

Common mistakes

Exercises that use Date.MonthName

Learn more

Related functions

Official documentation: Date.MonthName on Microsoft Learn.