Date.DayOfWeekName
The name of the weekday a date falls on, in the culture's language.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Date.DayOfWeekName(date as any, optional culture as nullable text) as nullable text| Parameter | Type | Description |
|---|---|---|
date | any | A date, datetime or datetimezone value; null gives null. |
culture | nullable text optional | A culture's name, such as "nb-NO", for its language; left out, the query's culture. |
Returns
nullable text. The weekday's full name.
Remarks
- Text follows the culture: the one given, else the query's (
Culture.Current), which is the model's Locale for import, else the model's own culture, else en-US. These examples run in en-US unless a culture is given. - Some languages write weekdays in lower case: Norwegian gives "fredag".
Examples
The weekday of an order
Date.DayOfWeekName(#date(2024, 3, 15))"Friday"In Norwegian
Date.DayOfWeekName(#date(2024, 3, 15), "nb-NO")"fredag"In German
Date.DayOfWeekName(#date(2024, 3, 15), "de-DE")"Freitag"