Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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"
another option
Date.ToText(#date(2022, [MonthNumber], 1), "MMMM", " en-US")
Hi Ahmedx,
Your suggested code works for me. Thank you so much!
And thanks for the very quick response too.
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"
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.
Hi, I copied in the string of code, but there is error in the code. Can someone help?
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |