Forum Discussion
Solved
Similar values to equal a common value
Hello All, First time poster. Slowly learning the power of Power Bi 🙂 I would like to create a custom column that evaluates, say column A, if the value contains "NHP" then have the value equal "N...
Something similar to this should work. It looks for NHP in Column A, no matter the case, and returns NHP if found, otherwise it returns the original value from ColA.
CustomCol = IF(CONTAINSSTRING(UPPER(ColA) "NHP"), "NHP", ColA)
Let me know if you have any problems with trying this out 🙂
ErikCR ,
Open Power query editor and do the following,
1. Go to add column at the top and click conditional column,
2. Name your new column and then choose the highlighted placeholder values based on your data,
3. In the else placeholder choose the highlighted symbol which means select a column if the above mentioned condition is not matched,
Thanks,
Arul
This is great Arul.
I think it will also make added additional conditions easier.
Erik