Forum Discussion
How to Sort a Custom Date Column
Hi ReemAlashhab ,
Approve with Avantika-Thakur , please try:
Create a new column weeknum:
Then use sort by column, choose weeknum:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Avantika-Thakur Can you show me the solution using screenshots and forulams ?
ReemAlashhab , Create a week start date
//Monday week
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
//Sunday week
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date])+1
And sort on that
any other week start
.Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
I tried to do that, but it doesn't work