Updated on

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
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.


Date.DayOfWeekName provides the day of the week name for a specified date. It can also accept an optional culture argument for localization (e.g., “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 Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: