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
6 Replies
PadycosmosSolution Sage
Add a column for MonthNumber and sort the DayMonth column by MonthNumber
- 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.
- 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:
