Sort by WeekDay Names

[mrrobottelg]

Hi,

I am not able to sort WeekDay names. I want to sort by Mon to Sun. please help

[mrrobottelg]

It worked. Thank you.

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

[rajendraongole1 · Accepted solution]

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!!