Excel PowerPivot: WEEKDAY Function (DAX)

Excel PowerPivot DAX Function & Features

WEEKDAY Function (DAX)

Syntax:

WEEKDAY(<date>, <return_type>)

Parameters:

date: A date in datetime format.

return_type: A number that determines the return value (An integer number from 1 to 7.)

Action:

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