Power Fx function
Weekday — Power Fx function reference
Day-of-week number.
Syntax
powerfx
Weekday( Date [, StartOfWeek ] )
Examples
powerfx
Weekday(Today())
→ 1 to 7
powerfx
Weekday(ThisItem.DueDate, StartOfWeek.Monday)
powerfx
If(Weekday(Today()) = 1, "It's Sunday")
Common mistakes & gotchas
- The default numbering (no StartOfWeek argument) treats Sunday as 1 — pass StartOfWeek.Monday explicitly if business logic assumes a Monday-start week, a common off-by-one source.
- Weekday returns a number, not a day name — pair with Text(date, "dddd") for the display name instead of a manual Switch on the number.
Related Power Fx functions
From Date & time