Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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    
Need Help
  • Padycosmos's avatar
    Padycosmos
    3 years ago

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

     

bolfri's avatar
bolfri
Solution Sage
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi tried that and it did not work

    • bolfri's avatar
      bolfri
      Solution Sage
      3 years ago

      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: