Create a column for month name from month number

[Anonymous]

Hello,

I have the following table loaded in Power BI and i would like to have a corresponding column with month name instead of numbers.

I am thinking to create a calculated column with corresponding month name but i am not sure how to do this.

I would also like to present this data in a column chart with the X axis as month name, but how to sort it by month name in order from January to December?

Any help is much appreciated!

Name	Month
Lizui	4
Laufenburg	7
Tegalpapak	8
Ar Rabiyah	8
Gangarampur	4
Bellegarde	3
Luntas	2
Seedorf	10
Frei Paulo	6
Bellegarde	3
Gangarampur	3
Cosamaloapan de Carpio	7
Luntas	2
Zagrodno	9
Lizui	4
Laufenburg	11
Tegalpapak	8
Ar Rabiyah	5
Gangarampur	3
Bellegarde	3
Luntas	5
Seedorf	1
Frei Paulo	6
Bellegarde	12
Gangarampur	3
Cosamaloapan de Carpio	7
Luntas	2
Zagrodno	9

[danextian]

hI @Anonymous 

You can create a date using those number and then use FORMAT to get the month name:

Month Name = 
FORMAT ( DATE ( 2022, Data[Month Number], 1 ), "MMMM" )

[VahidDM · Accepted solution]

Hi @Anonymous 

Add a new calculated column with this DAX:

Month Name =
FORMAT ( DATE ( 2022, 'Table'[Month], 1 ), "mmmm" )

Sample file attached.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[Anonymous]

@VahidDM Thanks for your reply! Is it possible to sort the month name in the correct order, starting from January and ending December?

[VahidDM]

Hi @Anonymous 

Yes, try to sort your Month Name column with Month name, Check this link:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-desktop

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube