Forum Discussion
Date Month Sort - In DIMDATE Table
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
Add a column for MonthNumber and sort the DayMonth column by MonthNumber
Hi tried that and it did not work
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: