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.
Hi,
Sorry if this is an easy one. So I have the following Column with these values:
Sales
Sales - Purchases
Sales - Compressers
I would like to do this in m query and my expected result would be:
Sales
Purchases
Compressers
Can someone please let me know how to do that?
Thank you
Solved! Go to Solution.
Hi @JohnLow
You can replace the string "Sales - "with nothing to get your desired result.
= Table.ReplaceValue(Source,"Sales - ","",Replacer.ReplaceText,{"Column1"})
Here's the full example query in my PBIX file (above)
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCk7MSS1WitWBshR0FQJKi5IzEovRRJ3zcwuKUouLU4uA4rEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Replaced Value" = Table.ReplaceValue(Source,"Sales - ","",Replacer.ReplaceText,{"Column1"})
in
#"Replaced Value"
Regards
Phil
Proud to be a Super User!
Hi @JohnLow
You can replace the string "Sales - "with nothing to get your desired result.
= Table.ReplaceValue(Source,"Sales - ","",Replacer.ReplaceText,{"Column1"})
Here's the full example query in my PBIX file (above)
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCk7MSS1WitWBshR0FQJKi5IzEovRRJ3zcwuKUouLU4uA4rEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Replaced Value" = Table.ReplaceValue(Source,"Sales - ","",Replacer.ReplaceText,{"Column1"})
in
#"Replaced Value"
Regards
Phil
Proud to be a Super User!
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |