Forum Discussion

RashmitaR's avatar
RashmitaR
Icon for Helper IV rankHelper IV
10 years ago
Solved

Sorting month name descending in order

Hi I am usinga a Matrix where in i have year and month name in my columns.Could someone please suggest a way to display the month name in descending order (i.e september,august,july,june,etc.)
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    RashmitaR

     

    You can create a MonthNum column with following formula. Then select the Month column and make it sorted by MonthNum column.

    MonthNum = 
- MONTH ( Table1[Date] )

     

    Best Regards,

    Herbert

RashmitaR's avatar
RashmitaR
Icon for Helper IV rankHelper IV
10 years ago

Hi v-haibl-msft

 

I tried your solution.It is working .Thanks

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

RashmitaR

 

In my last screenshot of matrix report, the Month names are in descending order like Sep, Aug, July, June in 2016.

What is your expected result?

 

Best Regards,

Herbert