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
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" )
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: