Date.DayOfWeekName

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

Syntax

Date.DayOfWeekName(
   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.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”).

Examples

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: https://learn.microsoft.com/en-us/powerquery-m/date-dayofweekname