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 all, I'm trying to replace some incorrect values in column A based on the values in column B. Essentially, I would like to change all of the values in Column A to "127" IF Column B = "table" without adding a new column.
I've tried to use the Replacer.ReplaceText and Table.ReplaceValue functions but can't seem to get it right. Appreciate the help
Current table
Column A | Column B |
124 | table |
124 | table |
125 | table |
Desired table
Column A | Column B |
127 | table |
127 | table |
127 | table |
Solved! Go to Solution.
Using → https://www.biinsight.com/quick-tips-conditionally-replace-values-based-on-other-values-in-power-que... as an example
Table.ReplaceValue(#"Changed Type", each [Column A], each if [Column B] = "table" then 127 else [Column A], Replacer.ReplaceValue,{"Column A"})
Proud to be a Super User!
= Table.AddColumn(#"Changed Type", "Custom", each if [Column B] = "table" then Replacer.ReplaceValue([Column A],[Column A],127) else [Column A])
Proud to be a Super User!
Hey @ChrisMendoza, I appreciate the help here. However I'd like to find out a solution that does not require adding a new column. Thanks!
Using → https://www.biinsight.com/quick-tips-conditionally-replace-values-based-on-other-values-in-power-que... as an example
Table.ReplaceValue(#"Changed Type", each [Column A], each if [Column B] = "table" then 127 else [Column A], Replacer.ReplaceValue,{"Column A"})
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |