Multiple Sorting Concatenated Column

[Anonymous]

Hello, I'm having some trouble sorting a concatenated colum.

My goal is to have a column which says the day and the 3 first letters of the month, for example, today "20 Sep"

I have a column for the day, another for the month and a third one which is calculated

 Date = 'Query1'[Day]&" "& LEFT('Query1'[Month];3)

I used "Sort by Column" in a fourth column which is the Month Number, so when I use it in a graphic it shows it in the correct order:

As you can see, it shows the months in order, but the days are disorganized

Please let me know if you need any more info that could help solve this issue. 

Thanks a lot in advance

[TomMartens · Accepted solution]

Hey,

I suggest you should create a column that contains a value that will be calculated like this month * 100 + day, then you can use this

column to order the date column.

• the value for the 5th of october will be 10 * 100 + 5 = 1005
• the value for the 2nd of april will be 4 * 200 = 402 

It may become necessary to consider a year as well, the value then will created by this little formula:

year * 10000 * month * 100 + day

Regards, 

Tom