Forum Discussion

rkh's avatar
rkh
New Member
6 years ago
Solved

Sorting by Month as Text (Jan Feb Mar etc)

I used Format to get mmmyy from Date. But in reports, data is being sorted alpha. I want mmmyy sorted by month
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    You need to create a sort column and use that as sort column for month

     

    Month sort = format(Date[Date],"MM")

    Month Year sort = format(Date[Date],"YYYYMM")

     

     

v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, rkh 

 

Based on your description, I created data to reproduce your scenario. 

 

Table:

Calendar :

Calender = CALENDARAUTO()
 
There is a one-to-one relationship between them.
 
You may use Year and Month columns from Calendar table to display the result.
 

 

 

Best Regards

Allan