Forum Discussion
week ending date day in wrong order help
I have a date table
and week ending date
week ending = 'Date'[Date]+(7-'Date'[weekdaynumber])
which works great
what I need to do is add the Day that rolls up to the weekending date under the weekending date, but it's getting ordered incorrectly, Ideally I would show weekending July 3rd, day 27, 28, 29, 30, 1,2,3
Anonymous , As the Only day does not have a month with it, you will not be able to set a sort column as weekend date.
But full dates like 3rd July 2021 (if formatted, mark week end date as sort column) , should sort correctly
How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c
2 Replies
- amitchandak
Super User
Anonymous , As the Only day does not have a month with it, you will not be able to set a sort column as weekend date.
But full dates like 3rd July 2021 (if formatted, mark week end date as sort column) , should sort correctly
How to Create Sort Column and Solve Related Errors: https://youtu.be/KK1zu4MBb-c