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!

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.

    • Vinod_P's avatar
      Vinod_P
      Helper I
      3 years ago

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

      Please guide

      • ThomasLe's avatar
        ThomasLe
        New Member
        2 years ago

        same problem here.

         

         

         

         

         

         

        Thanks to help!