Sort by Month without date column

Hi sdhn 

You can still sort by month by creating a 'Month Number' Index Column and sort the Month Column within the table using the 'Month Number' column. 

If the existing table has many rows, it may affect the speed with a new column created, so if that is the case I would suggest you to create a new table and establish a relationship between the two.

Hope this helps! If you need any clarification, feel free to reply.

Please Accept this as a solution if you think I answerd your question.

Thanks

Mahesh 

Solution:   

We completed the following steps: 

1. Created Month table that holds IDs for each month. 
2. Created calculated column in the original table holding the IDs of the second table:
   MonthNumberOfYear= RELATED(Reference[Month #])
   

    

3. Sorted calculated column:
   

    

4. Sorted month based on calculated column:
   

    

5. Refreshed visuals and confirmed changes.