Replace values with values in other column - Power BI

A very short video but a pretty helpful tip.

When you want to replace a value in a column, the standard 'Replace Values' doesn't allow you to reference another column. A tiny bit of M will allow you to do this in Power BI.

[mihirthakkar]

Hey @Power BI Guy I actaully added a custom column to replace the values. but this is super awsome. thanks a lot. cheers. And please keep adding such great tricks.

[matchanista]

perfect for my use case as well - ironically also trying to merge two temp reading columns. Thank you!

[syedaneesdurez]

Very gud tip. Hv seen first time such replacing values in PQ.. Amazing

[allrise]

Thank you. This was perfect for my issue today.

[brad]

This trick is huge and so useful. Thank you very much!

[cherrilreilly]

Cherril Reilly
exactly what i was looking for.
Many thanks

[andrewsinha]

Hi Ben, I have watched hundreds of Excel, PQ and PBI do you keep coming up with original content? Love your PBI file on FPL. Thanks Andrew. PS not just content cool content that is very very useful.

[newcovenantchurchstreatham]

Awesome, short and sweet, life saver stuff dude

[akshaypatil]

'Function' is written in cells after i followed your approach. What am i doing wrong???

[preetamgaikwad]

Hi, Let say if I want to replace the 0's with a value from a specific cell of column temp.max (lets say cell # 2 of that column)then what should be the formula? I dont want to hardcode that value but I was just reference that cell from the team.max column.

[Ozla]

Extremely helpful, thank you!
you've saved my day

[arjaypabunan]

Thank you for the detailed presentation. Very useful.

[powerb_i]

Thanks Ben, that's a really cool and quick BI tip! Great content.

[shreedharan.moorthy]

Hi Ben, your video is short and simple. I tried this, however not replacing values. Table.ReplaceValue(#"Removed Columns3", "YES", each [Ordered Item Quantity], Replacer.ReplaceText, {"CUT"})
can you help me ?

[tanhy]

Hi Ben, I am trying to use Dax to make changes to dates column by doing the same steps, but seems like the dates were not changed. Is there any formulary that I can use?

[imranm]

Hi Ben, this is great help. In your example, if there is a city column and you want to update the temp value only for 1 city, how can it be done? Please reply.

[solaagboola]

hello how can I add numbers to the new value and also divide it with a number ?

[akshaypatil]

One column has values 8806182550997, 1005RN07. How do i replace RN part from the second value with 00.

[daleanderson]

Hey FYI if you replace the "0" as a target with a "each[temp.min]" you can do the whole column not just the 0 values. "each[temp.min]" is your column name

[lidisontaveira]

You're fantastic! Thank you so much!