← Back to Date functions

Date.MonthName

This function retrieves the month name for the given date parameter. Users can also specify an optional culture code, such as "en-US", to further customize the output.

Syntax

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

About

This function retrieves the month name for the given date parameter. Users can also specify an optional culture code, such as "en-US", to further customize the output.

Explanation

Retrieve the name of the month. Syntax: Power Query MDate.MonthName(#datetime(2011, 12, 31, 5, 0, 0), "en-US") Result: "December"