Forum Discussion
karkar
Helper III
Helper IIIdate Sorting
Hello, I created the following columns and was confused with the sorting of the Month/Year . I still keep ketting February prior to January. Any thoughts
Thansk Again Phil.
I will remove Weeks and then only use Month/Year and DD fields.
I went to the modeling tab and sorted the data by M/Y Sort. It did the trick. Thanks again
Phil_Seamark
Microsoft Employee
Microsoft EmployeeAnother thing I notice is that your hierarchy has Month then Week.
Weeks don't always play nicely with Months given they don't share clean boundaries. This can often cause issues depending on how the weeks are linked to the months.
Note here how the 5th week in June 2016 also includes some dates from July. There is a small chance this can be upsetting your sorting.
karkarHelper III
Helper IIIThansk Again Phil.
I will remove Weeks and then only use Month/Year and DD fields.
I went to the modeling tab and sorted the data by M/Y Sort. It did the trick. Thanks again
- Phil_Seamark
Cool, Nice work