Forum Discussion
Sorting of Week Number with custom text
T_Sad ,
You need to have a numeric week and mark that as the sort column
Week Number = WEEKNUM([Date],2) //Week Number = WEEKNUM([Date],1) // 1 means sunday week
Week Name = "Week " & WEEKNUM([Date],2)
Sort Week name on week number: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Refer to my Video Sort and its challenges: https://www.youtube.com/watch?v=KK1zu4MBb-c
Super UserT_Sad ,
You need to have a numeric week and mark that as the sort column
Week Number = WEEKNUM([Date],2) //Week Number = WEEKNUM([Date],1) // 1 means sunday week
Week Name = "Week " & WEEKNUM([Date],2)
Sort Week name on week number: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Refer to my Video Sort and its challenges: https://www.youtube.com/watch?v=KK1zu4MBb-c
Thank you for the quick reply. Saved the day