Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
Anonymous
Not applicable

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

 

parminderkellah_0-1673625643510.png

 

1 ACCEPTED SOLUTION
Padycosmos
Solution Sage
Solution Sage

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

Padycosmos_0-1673626616474.png

 

View solution in original post

6 REPLIES 6
Padycosmos
Solution Sage
Solution Sage

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

Padycosmos_0-1673626616474.png

 

Anonymous
Not applicable

Hi Tried that too - but does not work too

Padycosmos_0-1673626806869.png

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
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

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.

 

bolfri_1-1673626692594.png

Oryginally you have wrong order on your visual like this:

bolfri_2-1673626747217.png

 

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:

 

bolfri_3-1673626820957.png

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.