Replicating Excel's Weekday function into Tableau

Featured Image

Excel holds a WEEKDAY() function returning the integer day number of the week. In order to get the same result in Tableau, use the DATEPART() function, taking the weekday part of a specific date.

E.g.

DATEPART('weekday', Today())

or

DATEPART('weekday',[Date Field])