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,

Seng's avatar
Seng
New Member
8 years ago

I created Year, Month and Day column and used MonthName = format(date('Calendar'[Year],'Calendar'[Month],'Calendar'[Day]), "mmmm") for the MonthName column.