WEEKDAY DAX Function

The function returns a number from 1 to 7 identifying the day of the week of a date. By default, the day ranges from 1 (Sunday) to 7 (Saturday).

DAX Syntax WEEKDAY(date, return_type)

Example: The following expression returns the weekday of the date.

DAX

Weekday num = WEEKDAY(Sheet1[Dates])
WEEKDAY dax function