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.
Hope you have a good day,
I have a column with different values, how i can edit multiple cells in a column using edit query in Power BI
For Example i have below column:
Category |
brown |
yellow |
blue |
light blue |
brown |
light brown |
light blue |
I need below output:
Category |
Brown |
Yellow |
Blue |
Blue |
Brown |
Brown |
Blue |
Thanks in Avance
Solved! Go to Solution.
Hi, @vat2do
If you are not good at coding, you can also try the buttons on the visual interface.
Please try following steps:
1. Select column 'Category' ->go to 'Transform' ->replace Values
Replace Value 'light ' with Value ''
2. go to 'Transform' ->'Format' ->'Capitalize each word'
Result:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @vat2do
If you are not good at coding, you can also try the buttons on the visual interface.
Please try following steps:
1. Select column 'Category' ->go to 'Transform' ->replace Values
Replace Value 'light ' with Value ''
2. go to 'Transform' ->'Format' ->'Capitalize each word'
Result:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Your solution is in DAX or some other language
In power Query, not in Dax.
@vat2do In power query first select column and replace "light " with blank
Then transform the column by category "capitalize each word"
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSirKL89TitWJVqpMzcnJLwczk3JKU8GMnMz0jBIFOBehGCqBzgcrjAUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Category = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Category", type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type","light ","",Replacer.ReplaceText,{"Category"}),
#"Capitalized Each Word" = Table.TransformColumns(#"Replaced Value",{{"Category", Text.Proper, type text}})
in
#"Capitalized Each Word"
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |