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.
I have Table with two column. first column is "Indicator" and second column is "Sub-Indicator". I want to replace all the indicator value with coresponding Sub-Indicator value.
Solved! Go to Solution.
@nandukrishnavs,
Add a new blank query in Power BI Desktop, then paste the following code into Advanced Editor of the blank query. Please note that the highlighted code do the replace value job.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUUpRitWJVnICslLBLGcgK00pNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Indicator = _t, #"Sub-Indicator" = _t]), #"Replaced Value" = Table.ReplaceValue(Source,each [Indicator],each [#"Sub-Indicator"],Replacer.ReplaceText,{"Indicator"}) in #"Replaced Value"
Another method is to duplicate the sub-indicator column, and then remove the Indicator column.
Regards,
Lydia
@nandukrishnavs,
Add a new blank query in Power BI Desktop, then paste the following code into Advanced Editor of the blank query. Please note that the highlighted code do the replace value job.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUUpRitWJVnICslLBLGcgK00pNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Indicator = _t, #"Sub-Indicator" = _t]), #"Replaced Value" = Table.ReplaceValue(Source,each [Indicator],each [#"Sub-Indicator"],Replacer.ReplaceText,{"Indicator"}) in #"Replaced Value"
Another method is to duplicate the sub-indicator column, and then remove the Indicator column.
Regards,
Lydia
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 |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
80 | |
72 |