Forum Discussion
replacing values based on another column using M
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" witho...
Using → https://www.biinsight.com/quick-tips-conditionally-replace-values-based-on-other-values-in-power-query/ as an example
Table.ReplaceValue(#"Changed Type", each [Column A], each if [Column B] = "table" then 127 else [Column A], Replacer.ReplaceValue,{"Column A"})
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!
ChrisMendoza
Resident Rockstar
Resident RockstarUsing → https://www.biinsight.com/quick-tips-conditionally-replace-values-based-on-other-values-in-power-query/ as an example
Table.ReplaceValue(#"Changed Type", each [Column A], each if [Column B] = "table" then 127 else [Column A], Replacer.ReplaceValue,{"Column A"})