Date.DayOfWeekName is a function in the Power Query M language that returns the name of the day of the week for a provided date. An optional culture may also be provided.

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


   date as any,
   optional culture as nullable text,
) as nullable text
Argument Attribute Description
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.


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


Get the day of the week name.

// Output: "Saturday"
Date.DayOfWeekName( #date( 2011, 12, 31 ), "en-US" )

Learn more about Date.DayOfWeekName in the following articles:

Other functions related to Date.DayOfWeekName are:

BI Gorilla Youtube Channel

Last update: December 1, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.