Forum Discussion
Replace value on filtered column
Hello all I am trying to do the following and I am stuck. I want to filter in a column for a specific value, let that be for example Column A - "Cost Center ABCD". Once I filter, i want to r...
lkalawski
Resident Rockstar
Resident RockstarHi fanisgeorg,
You probably do it in Power Query. As you can see, you add the next steps in editing. The first step is data filtering and the second step is data replacing. Each step contains its own data set, so only filtered data goes to the last step.
To achieve what you want, you must do the following change:
Instead of using Filtered Rows and Replaced Value1 lines, please use only the last line: Replaced Value . There is a condition in which the value is to be changed.
#"Replaced Value" = Table.ReplaceValue(Source,each [Column B],each if [Column A] = "Cost Center ABCD" then "KLM" else [Column B],Replacer.ReplaceValue,{"Column B"})
If I helped, please accept the solution and give kudos! 😀