Sort week start and end by week-year

[malualves]

I have a calendar table with a column with "Week Start End" (28/11 - 4/11 is an example of a line....etc). I want to sort by year-week (2021-1, 2021-2...etc). The problem is when I have one week in the end/start of a year. For example, the last week of 2020 begins in 28/12/2020 and end in 03/01/2021. In this case, I have two values of year-week for the week 28/12 - 03/01) (image above). How can i sort the column Week Star End"?

[v-angzheng-msft · Accepted solution]

Hi, @malualves 

You can try to sort directly by start of week or end of week in your data.

Sort Column = 
RANKX('Table',[Start of Week],,DESC,Dense)

Result:

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@malualves , I prefer to sort on week start or week end date

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

I would mark one of the two as sort column