Forum Discussion

fbjras12's avatar
fbjras12
New Member
9 years ago

Months in the wrong order

I made a spreadsheet with 3 tables. One of them relates Months, Results and goals. Only in the panel months are appearing in the wrong order. I would like it to appear in the order of the annual cale...
Tutorial Requests
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi fbjras12,

 

The default sort order for text columns is alphabetically so I'm guessing your months are sorting this way?

 

To fix you'll need another column to control the sort order.  Preferablly using a numeric format.

 

I always add this column to my Date/Calendar tabales

 

MonthID = INT(FORMAT('Dates'[Date],"YYYYMM"))

And use this option on my Month column to tell it to sorth by the MonthID column.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    fbjras12

    Try this in the Query Editor:

    Table.AddColumn(<YOURLASTSTEP>, "YYYYMM", each "2017."&Number.ToText([Mes]))