Power Query - Bulk Replace Values in One Step 🔄📊

[@garywilhelm2299]

This is a truly great video. I have watched several bulk replace videos from other PQ UA-camrs and BA Sensei has by far the most efficient code for accomplishing this task. It is genius to use the 3rd (default transformation) argument of the Table.TransformColumns function to replace values in ALL columns using the translation table. Great stuff!

[@basensei8699]

thank you very much!

[@patrickyoung2106]

Yes, back with another tutorial!!!

[@hseyedagha]

That was awesome, saved me 5 hours probably and increased performance hugely.

[@basensei8699]

that so great!

[@kebincui]

Excellent👍👍

[@roywilson9580]

That's a neat trick :)

[@siddheshamrutkar8684]

Superb.. 🤘

[@mnowako]

Mind blowing! Many thanks!

[@bghneim]

Excellent thank you

[@jianlinchen7978]

勉強になりました

[@Rahul.parmar8439]

replace bulk with begin with replace possible
Example name in Mr. Dr. Miss Miss.. m/s begin with value replace use to power QUERY possible

[@josh_excel]

If you wish to replace partial values like letters in a word, I have a couple of methods include this one using recursion:
ua-cam.com/video/VWFYE-DOylo/v-deo.html

[@basensei8699]

i love your videos

[@ajayrathod7777]

getting error in last step :Expression.SyntaxError: Token Comma expected. code = Table.TransformColumns(Source, {}, each List.ReplaceMatchingItems({_}, Find_Replace List){0})

[@alterchannel2501]

this is great, you are the only one who nailed this solution . others use list.accumulate, but that method doesn't work properly. Only one question, on very big datasets will this be slow considering that it is iterating all the table and not just the column we want to change?

[@thebhaskarjoshi]

Superb.. 🤘

[@basensei8699]

Thanks 🤗