Forum Discussion
mkane12
Helper I
Helper Isorting months in order
how can I sort my months in order?
Hi mkane12 ,
Thank you for your follow-up, and you’re correct to highlight that. If you’re already using a date table, such as a Calendar table with all dates included, there’s no need to create a separate Month table just for sorting. You can sort the month names directly in your existing date table.
Make sure your table has a column for the month name (like "January", "February") and another for the month number (1 to 12).
Thank you.
parry2k
Super User
Super Usermkane12 if you don't have a sorting column (month number) on which you want to sort month names, nothing will work. You need to create a column for sorting. Read more about it here Sort one column by another column in Power BI - Power BI | Microsoft Learn