Forum Discussion
Adding month names and sorting accordingly
Hello,
I have a report with a direct connection to SQL, with the column of months listed as numbers from 1 to 12.
Now, in my visuals, I would like to present these months with names (Jan to Dec), and then sort them chronologically.
How can I add a new column, that would provide me with month names, depending on the number of the month?
So, if I have number 1, I would like a "January" in a column next to it... Hope I am clear.
And the reporting is updating itself. Currently I only have months from 1 to 6, and soon the 7 will be imported. I would like to have a July for it ready 🙂
Thanks in advance.
In your Date table using Power Query, use:
Table.AddColumn(#"Replace_with_previous_step_name", "Month Name", each Date.MonthName([Date]), type text)
This way, you have a column of Month names in your Date table. Make sure you also have that column of Month Numbers in the same date table. Then, once you have loaded everything and are in the main interface, go over to the Table view and open your date table. Select the Month Name column, click Sort By, and select the month number column. Once this is done, your model will show the correct order of months.
4 Replies
In your Date table using Power Query, use:
Table.AddColumn(#"Replace_with_previous_step_name", "Month Name", each Date.MonthName([Date]), type text)
This way, you have a column of Month names in your Date table. Make sure you also have that column of Month Numbers in the same date table. Then, once you have loaded everything and are in the main interface, go over to the Table view and open your date table. Select the Month Name column, click Sort By, and select the month number column. Once this is done, your model will show the correct order of months.
Anonymous , if you have a number for month, You can mark that as sort columns. Else you have to create one
