Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
This issue is a common theme addressed by many bloggers. Here is one.
This issue is a common theme addressed by many bloggers. Here is one.
User | Count |
---|---|
20 | |
10 | |
10 | |
9 | |
7 |