Forum Discussion
Replace value in one cell based on condition on another
Hi, I'm very new to PowerBI and I need your help. I tried various options including conditional columns, but it doesn't seem to work. They all add extra columns, that I would like to avoid. I'm r...
There are several things that you can try.
1. Click over 'CORPOR' AND 'BMW FINANCE NV' and select the text in order to check that you don't have spaces at the end of your text. (if you have spaces remember that you can trim the columns)
2. You could try to use Replacer.ReplaceValue instead of Replacer.ReplaceText.
3. If it doesn't work, you could try to change types and use both replaces again.
4. If nothing works, you could try to use Text.Contains([Categorie], "CORPOR").
I've noticed that the name of the column is in capital letters but it's not in the formula. I supose because it's an example.