Forum Discussion

mrrobottelg's avatar
mrrobottelg
Frequent Visitor
2 years ago
Solved

Sort by WeekDay Names

Hi,   I am not able to sort WeekDay names. I want to sort by Mon to Sun. please help    
  • rajendraongole1's avatar
    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!!