Forum Discussion
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 "NHP". Else, do not change the value that is there already.
The table contains values such as NHP +4, NHP Chair, NHP Pole, Etc. All these can be summed up as "NHP"
I hope that is clear. I think I may be using poor terminology 😞
Thank-Erik
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 🙂
4 Replies
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
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
