Forum Discussion
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 error.
Can help me?
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"
6 Replies
another option
Date.ToText(#date(2022, [MonthNumber], 1), "MMMM", " en-US")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!
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")Hi, I copied in the string of code, but there is error in the code. Can someone help?
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"
