FORMAT() returns Month Number

[Nicolas]

Hi

I'm trying to convert Month numbers (1,2,3...12) in text (January, February,...).

I tried :

=FORMAT(MONTH([MyColumn]), "mmmm")

Anyway i could return some text?

Thanks!

[bhope]

Hello, 

I am getting only January when using Format(Month([ColumnName])),"MMMM")

Format(Month([ColumnName])),"MMMM") = January

Format(Month([ColumnName])),"MMM") = Jan

Format(Month([ColumnName])),"MM") = 01

Format(Month([ColumnName])),"M") = 1

Columns data is stored as datetime format

not sure what is caysing this problem?

[KHorseman]

@bhope I assume this is for a second column and not a measure? You don't need the MONTH function. FORMAT(TableName[ColumnName], "MMMM") will return the month. Make sure you're using TableName[ColumnName] not simply [ColumnName].

[Seng]

I created Year, Month and Day column and used MonthName = format(date('Calendar'[Year],'Calendar'[Month],'Calendar'[Day]), "mmmm") for the MonthName column.

[KHorseman]

=FORMAT(MONTH([MyColumn]), "MMMM")

Capitalization counts. https://msdn.microsoft.com/en-us/library/ee634398.aspx

[Nicolas]

Thanks but it now returns only January...

Is there not another way of doing the same thing?

Thanks!

[Qwer1234]

I am facing the same error as well. I am only getting January. Could anyone help?

[v-caliao-msft · Accepted solution]

Hi @Nicolas,

You can get the month name by using the DAX below.
MonthName = FORMAT(DATE(2016,Table1[MonthNumber],1),"MMMM")

OR

Month Name = SWITCH(Table1[MonthNumber],1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November",12,"December")

Regards,

[Anonymous]

Hi @v-caliao-msft,

is there in a difference in terms of performance, with direct query in place?

Thanks in advance.

regards

Alex

[KHorseman]

Oh yeah, the MONTH() argument shouldn't be there at all. FORMAT works on the entire date value.

FORMAT(TableName[Date], "MMMM")

[trebgatte]

Try FORMAT(TableName[Date], "MMM") for the three letter month name as well.

[Vinod_P]

Not sure where I did wrong , I am getting month number 01 as Dec instead of Jan

Please guide

[ThomasLe]

same problem here.

Thanks to help!