Forum Discussion

bo_afk's avatar
bo_afk
Post Patron
6 years ago
Solved

Sorting a day-month column

Hi,   I've created a day-month column using the short month name, and day of the month number in my dataset to obtain the following format dd-ShortMonthName, e.g. 01-Sep, 02-Sep...10-Dec etc. How c...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi bo_afk 

     

    I think you should create a column like MMDD like 01-Jan, 02-Mar would be 0101, 0302, That will sort on month and date.

    What you need is a numeric column to use as the sort order.

    MonthDaySort = MONTH ( uvw_RescoMobileAudit[Created On] ) * 100 + DAY ( uvw_RescoMobileAudit[Created On] )

    Then you set the sort on the Month/Day to use MonthDaySort.  In the image below I am setting the sort order on [Month Name] to use [Month Number].

     
v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi bo_afk 

 

I think you should create a column like MMDD like 01-Jan, 02-Mar would be 0101, 0302, That will sort on month and date.

What you need is a numeric column to use as the sort order.

MonthDaySort = MONTH ( uvw_RescoMobileAudit[Created On] ) * 100 + DAY ( uvw_RescoMobileAudit[Created On] )

Then you set the sort on the Month/Day to use MonthDaySort.  In the image below I am setting the sort order on [Month Name] to use [Month Number].