Date.MonthName

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

Argument	Attribute	Description
date
culture	optional	The 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

Returns the name of the month component for the provided date. An optional culture may also be provided (for example, “en-US”).

Examples

Get the month name.

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

Related articles

Learn more about Date.MonthName in the following articles:

• Create Date Table with Dynamic Language in Power Query
  Want your Date Table in Multiple Languages? This post explains how to make your calendar dynamic to support any language or culture. » Read more
• Create Date Table or Calendar in Power Query M
  Learn how to create a dynamic calendar table in Power Query’s M language. Build your custom columns and claim your free Date Table Script. » Read more

Related functions

Other functions related to Date.MonthName are:

• Date.DayOfWeekName

Last update: December 1, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/date-monthname
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.