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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

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

       

      FORMAT(TableName[Date], "MMMM")

      • trebgatte's avatar
        trebgatte
        Most Valuable Professional
        9 years ago

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

    • Qwer1234's avatar
      Qwer1234
      Regular Visitor
      6 years ago

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