Forum Discussion
FORMAT() returns Month Number
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!
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,
12 Replies
=FORMAT(MONTH([MyColumn]), "MMMM")
Capitalization counts. https://msdn.microsoft.com/en-us/library/ee634398.aspx
Thanks but it now returns only January...
Is there not another way of doing the same thing?
Thanks!
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,
I created Year, Month and Day column and used MonthName = format(date('Calendar'[Year],'Calendar'[Month],'Calendar'[Day]), "mmmm") for the MonthName column.
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?
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].
