date Sorting

[karkar]

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

[Phil_Seamark]

Do you have a separate DATE table with 1 row per day?

If not, I recommend you do for more reasons than this.  It will make sorting and hierarchies tidier.

So at the very least add the following table 

Dates = CALENDARAUTO()

And then create a relationship between this table and your Query table

[karkar]

Thanks Phil. I will make sure I have a date table connected . But it is strange that it worked the other day using those formulaes.

There wasnt any problem with February going prior to January!!!!

Regards

[Phil_Seamark]

Another 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.

[karkar · Accepted solution]

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]

Cool, Nice work