Date.MonthName

Updated on

Date.MonthName is a Power Query M function that returns the name of the month component for the provided date. An optional culture may also be provided.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Date.MonthName(
   date as any,
   optional culture as nullable text,
) as nullable text
ArgumentAttributeDescription
date
cultureoptionalThe culture argument enables the specification of a Culture code (e.g., “nl-NL” or “en-US”) to align transformations with local formatting conventions. If this argument is omitted, functions default to Culture.Current, which reflects the system’s regional settings.

Description

Date.MonthName returns the month name for a given date. It can include an optional culture argument for localization (e.g., “en-US”).

Examples

Get the month name.

// Output: "December"
Date.MonthName( #datetime( 2011, 12, 31, 5, 0, 0 ), "en-US" )

Learn more about Date.MonthName in the following articles:

Other functions related to Date.MonthName are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/date-monthname