Forum Discussion

HxH's avatar
HxH
Advocate II
6 years ago
Solved

Replacing multiple values with a switch-like function in M

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.