Forum Discussion
mrrobottelg
2 years agoFrequent Visitor
Sort by WeekDay Names
Hi, I am not able to sort WeekDay names. I want to sort by Mon to Sun. please help
- 2 years ago
Hi mrrobottelg - In your date table, create one calculated column with Day Number as below and sort it on the top of column Week day with Day number.
calculated column as below:
DayNumber = WEEKDAY([Date], 2)Once created new column sort the Name of the day (Week day in your case) with sort by column Day Number as below image:Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
mrrobottelg
2 years agoFrequent Visitor
It worked. Thank you.