week ending date day in wrong order help

[Anonymous]

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

[amitchandak · Accepted solution]

@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

[Anonymous]

That's the route I was going down, working on figuring out a column to sort the day on now

alternativly it works if I add month in above day from my regular date hierarchy