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,

Nicolas's avatar
Nicolas
Frequent Visitor
9 years ago

Thanks but it now returns only January...

Is there not another way of doing the same thing?

Thanks!

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-caliao-msft,

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

    Thanks in advance.

    regards

    Alex