Date Month Sort - In DIMDATE Table

[Anonymous]

Hi Experts

How would you sort the a DD MMM column in a DimDate table (see column image i need to sort) in day month order

[Padycosmos · Accepted solution]

Add a column for MonthNumber and sort the DayMonth column by MonthNumber

[Anonymous]

Hi Tried that too - but does not work too

[Padycosmos]

Did you select the DayMonth coumn and Sort by Month Number column?,

We are sorting one column based on the values of another column, It works for me

[bolfri]

You need to have additional column (eg. oryginal_date) with standard date type format eg 2022-01-13 and then you can select your DayMonth column and select Order by oryginal_date. Note that it won't work correctly if you will have 2 same dates eg 11 May = 11 May 2022 || 11 May 2023 would have different order value.

[Anonymous]

Hi tried that and it did not work

[bolfri]

Let's assume you have such column as a text:

DayMonth

08 Jan

09 Jan

10 Jan

11 Jan

12 Jan

05 Mar

06 Mar

07 Mar

08 Mar

In Power Query M add custom column that is duplicate of your existing column, but formatted as a date.

Oryginally you have wrong order on your visual like this:

But if you will do like I said so select DayMonth column and with Column tools set "Sort by column" as DayMonth - as date you will get something like this: