Replace text with another column value in Power Query

Do you know how to replace text dynamically in Power Query using another column's value? Let me show you!


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[AJM]

Awesome. I'll have to remember that one, not sure how often it'll come up but 'each' is a handy code!
Thank you 🙂👍🏻

[antoniogoncalves]

Hello from Portugal. Can you please help me with this problem? I have everyday a table with 1 column with the day before today, when I promote the headers I will have the day as header and I must change the name to date… it works fine today, but tomorrow I will receive one error because the day was no longer the same. Of course all this in power query. Thank you very much for your help

[HachiAdachi]

😮 so simple yet so effective... I LOVE these PQ tricks! More, please! 😁

[ewad]

Thank you :) You are totaly my go to source for everything new and awesome!

[glennwatts]

This is incredible!!! I was searching for hours to find a solution to this exact issue. Thanks so much!

[eedanagarjunareddy]

Hi ma'am,

I need one help, I want to open my report in particular countries like USA, UK, Canada, Germany. In this I want change time dynamically. Means if I want open in USA then I want to see the USA timings, Could you please help me

[JumpRPicturs]

quite useful.
I've been wondering whether this can also somehow work with individual parts of the value in a column, specifically with different parts of dates (days, months, years) and both in what you want to search and replace and in what you want the new value to be (e.g. replacing part of a text with a month or a year extracted from another column)
I tried a lot of things but couldn't find a way to do it without deconstructing values in different columns and reassembling with new values in yet another new column... and it's okay for a small range of data but not for entire databases I actually need to do it for, spanning years of data and hundreds of separate files with thousands of rows of data each, and updating possibly daily...

[Alexandra-scxr]

Is it possible to replace a value and move it one row down? Or is that only possible with an index?

[MM-nrnf]

You are awesome 👌. Learning a lot from you. Thanks.

[elbadlis]

Thank you for this wonderful tutorial. So cool!

[bouseuxlatache]

i was expecting barcelona vs madrid...well the example is still very clear :) thanks.

[ambalan]

Thanks for the videos. Please help me. I added new column after power query but whenever refresh happens, new rows from source data will offsets the added column.

[isaacmuhanga]

Dear Curbal, i really love your tips. I am just wondering if there is a way I can use replace function conditionally to achieve this---if column A is "aa" then replace the 23 in column B with 10 from Column C

A B C
aa 23 10
das 44 51
fdd 21 30

and the output should be something like this:

A B C
aa 10 10
das 44 51
fdd 21 30

Please help

[RyuzakiF]

How can I concatenate the value of other 2 columns to be the replacement value?

[srikantmukherjee]

Can we Replace any Text Before a Delimiter in Power Query?
Like I have below Excel
Zone - MP
Region - Veg
Nepal
State-Bhtan
Dubai

In ExcelSheet, Find and Replace, We do like * - and Replace All

What to be Used in Power Query to Replace any Text or Value Like We use * in Excel Sheet

Please Help

[Hemanth]

Hi Curbal,

Could you please help us in creating a report which generally call an API (export to file). This API needs to call the paginated report and download the data in CSV file. This requirement is getting popular in many projects now. If you can create a video on this that would really help many of us. Thanks

[joseagundis]

Ruth, thanks for sharing it, very useful!!!

[Bharath_PBI]

Thank you Ruth. 👍 Will the query fold when doing this?

[hafizurrahman]

How can I replace space instead of And:01 And:02 And:03 in power query.

[curtisgregson]

I give up... I've looked everywhere for the pbix files but I cannot find them