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])