Replace Number by text

[ana_cordeiro]

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 error.

Can help me?

[Ahmedx]

another option
Date.ToText(#date(2022, [MonthNumber], 1), "MMMM", " en-US")

[STM4508]

Hi Ahmedx, 

Your suggested code works for me. Thank you so much!

And thanks for the very quick response too. 

[v-frfei-msft · Accepted solution]

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]

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]

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

[vinaypugalia]

Hello,

Could you please share some sample data & the expression you have written to get the required text?

This will give anyone who wants to help you to get more insight & guide you further.

Thanks!