Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
HxH
Helper II
Helper II

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. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

This issue is a common theme addressed by many bloggers. Here is one.

 

https://www.howtoexcel.org/power-query/bulk-replace-values/

View solution in original post

1 REPLY 1
Anonymous
Not applicable

This issue is a common theme addressed by many bloggers. Here is one.

 

https://www.howtoexcel.org/power-query/bulk-replace-values/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors