Replace Multiple Column Values in One Step [Power Query Tips & Tricks]

This week's video tutorial is an exciting one as we demonstrate how to dynamically replace multiple column values with one single step in Power Query. This technique will work both in Microsoft Power BI and Excel.

In a previous video, we explained how to replace one single column value using Power Query's user interface. This video builds on that and we show you how to use M language to code a dynamic way of replacing multiple column values without too many steps and in a much quicker way.

For more how-to and tips & tricks videos on Power BI make sure to subscribe to our channel.

About Go Analytics Inc.

We are data analysis and visualization consultants specializing in Power BI. We help organizations create and nurture a data culture.

Need help getting started with Power BI? Let's connect!

Song used is Kubric's Cube by _91nova from Epidemic Music. All credit goes to the artist.

***
Note: Go Analytics Inc. is not affiliated with Microsoft. Thoughts are our own.

[johannesvandorsten]

This is really good! Broadly applicable to many situations, gives answers to questions I didn't even know I had and just saves an immeasurably amount of time working with PowerBI. (And who doesn't enjoy a neat looking step list =)

[rauljimenez]

Great breakdown of the build-up of the structure of the command you were changing. Thank you for sharing!

[theabhishekshaww]

I love you 😭 because of this impressive information you made impression in front of everyone in the office. Thank you ❤

[darwincampbell]

Perfect explination and example, thank you for putting this together.

[tommynielsen]

Thank you so much!! I have looked for this for six month

[oswinaria]

is this same results with using Merge ?

[hamzamottali]

thank you it's very helpful, but what if i wanna replace juste a part of the value not the whole value, for exemple : my value is : ABCDDD and i wanna juste replace the DDD by 111 and so on for the other values, can i do that in one step for more then 100 value in column ?

[indomartblog]

How about if you have multiple columns that you want to change values let's say to null.

[dhwxfey]

a pretty clumsy method but still better than 10 steps of Replace Vlue 👏

[michaelbrandel]

Is there also a way to dynamically iterate over columns matching a specific name pattern and replace a value?

[sofiabellen]

What if you’re trying to replace a value that the column contains to standardize it, like address abbreviations?

[arne.munther]

I would love to see a rutine where you pull the Province data from a table, so its not hardcoded.

[PhenixFan]

Wouldn't it be more efficient to create a reference table, and merge the queries, then use the new column?
It's easier to maintain a table, than having to update your code over time.

[sujitnair]

what difference it made ? adding a one step doesn't make a much difference though. this does make work more

[alterchannel]

You save steps, but not time. Download a table (you really don't even have to download it) from internet and just merge the queries.