Forum Discussion
Replace several values with three from same column
Hello, I struggle with a situation and I need your help to understand how to solve it. I have a query in Power BI and I want to replace information from one column as mention below. I know how t...
tamerj1
Community Champion
Community ChampionHi Tabita88
With power query you can perform left outer join and retrieve the new values, you can then add a conditional column where if the new value is null return the old of and if not return the new one.
With DAX you can have 'Repalcements' as a lookup table tp retrieve the new name whenever needed.