Hi everyone,
I am currently replacing values in Power Query and I would like to know how I can replace a bunch of them using a single function, reproducing a behaviour similar to the DAX SWITCH function
#"Replaced Value1" = Table.ReplaceValue(#"Filtered rows","Clio-2016","Clio",Replacer.ReplaceText,{"Model"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","Kuga-2016","Kuga",Replacer.ReplaceText,{"Model"})
in
#"Replaced Value2"
I have copied the last two rows of my advanced editor so that you have a reference to use with my data. As you can see I did the clio and the kuga replacement in two different steps but I would like to do both in one (I have to do like a hundred of these, so I want a faster way than having to manually replace all the values with the button)
Also nevermind the fact that I have removed "-2016" in both, it is just a coincidence. The data have very different formats and I can't to a trim or a split by delimiter.
