Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
Add a column for MonthNumber and sort the DayMonth column by MonthNumber
Add a column for MonthNumber and sort the DayMonth column by MonthNumber
Hi Tried that too - but does not work too
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
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.
Proud to be a Super User!
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:
Proud to be a Super User!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
85 | |
66 | |
49 |
User | Count |
---|---|
140 | |
113 | |
104 | |
64 | |
60 |