Forum Discussion
Sort by WeekDay Names
Hi,
I am not able to sort WeekDay names. I want to sort by Mon to Sun. please help
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!!
3 Replies
- rajendraongole1
Super User
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!! - Ashish_Mathur
Hi,
In the Calendar table, create a calculated column formula to extract the Day of week
DoW = format(calendar[date],"dddd")
In MS Excel, create a 2 column by 7 row table with day names in column 1 and order of those day names in column 2. Name this table as doworder.
Day name Day order Monday 1 Tuesday 2 Wednesday 3 Thursday 4 Friday 5 Saturday 6 Sunday 7 In the Calendar Table, write this calculated column formula to brin over the Order column from another table
Dow order = related(doworder[order])
Click on any cell in the Dow column of the Calendar table and under Sort by column, select Dow order. to your visual, drag Dow from the Calendar Table.
It worked. Thank you.
