Forum Discussion
Solved
How to Sort a Custom Date Column
Hi Everyone , I have a date table that has : date , year , month , quarter and ect. In addition, there is a new column I created it's called Week. The format for this column is : ( W + Week Number...
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.
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