Forum Discussion

ana_cordeiro's avatar
ana_cordeiro
Regular Visitor
7 years ago
Solved

Replace Number by text

Hello,   I'm replace the Numbers os one Month column by Text (replane 1 by January, 2 by February...).   When I try replace 10 by October, 11 by November and 12 by December, appear attachment err...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi ana_cordeiro ,

     

    To create a custom column as below.

     

    Date.MonthName(#datetime(2011, [monthno], 1, 5, 0, 0), "en-US")

     

    M code for your reference.

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMgKTxmDSBEyagkkzMGkOJi3ApCWYNDSAUBDdhkDtsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [monthno = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"monthno", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Date.MonthName(#datetime(2011, [monthno], 1, 5, 0, 0), "en-US"))
in
    #"Added Custom"
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
7 years ago

Hi ana_cordeiro ,

 

Its quite unknown which formula you are using to map month number with month name. I suggest you to use the SWITCH expression to accomplish your requirement.

 

MonthName = SWITCH('Month'[MonthNumber],1,"January",2,"Febuary",3,"March",4,"April",5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November",12,"December","Invalid")
STM4508's avatar
STM4508
New Member
3 years ago

Hi, I copied in the string of code, but there is error in the code. Can someone help?