Forum Discussion

Nicolas's avatar
Nicolas
Frequent Visitor
9 years ago
Solved

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!    
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    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,

bhope's avatar
bhope
New Member
5 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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].