Forum Discussion
Months in the wrong order
Microsoft EmployeeHi 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.
Thanks, but this appear. Link: https://drive.google.com/file/d/0B1b9zTy_CQcRV3M3WnByTEg3RVU/view?usp=sharing
Thanks, but this appear. Link: https://drive.google.com/file/d/0B1b9zTy_CQcRV3M3WnByTEg3RVU/view?usp=sharing
Try this in the Query Editor:
Table.AddColumn(<YOURLASTSTEP>, "YYYYMM", each "2017."&Number.ToText([Mes]))
or better:
=Table.AddColumn(<YOURLASTSTEP>, "YYYYMM", each Number.FromText("2017")*1000+[Mes])
