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 🙂
Awesome.
Thank you.
I just needed to add a comma between ...(UPPER(ColA) and "NHP") then the formula worked.
Now, I'll see if I can next additional conditions 😉
Erik