Forum Discussion
New Column BAsed on Keywords
Hi Guys, new to PowerBi and really need some help.
I have a table called Leads and it looks like the below:
| Name | Job Title |
| Joe Bloggs | Reporter Analyst |
| James Cloney | Data Reporter |
I need to add a new column to this table based on predefined (i have a list myself) keywords from the Job Title column. For example, the above table should now look like this:
| Name | Job Title | Main Title |
| Joe Bloggs | Reporter Analyst | Reporter |
| James Cloney | Data Reporter | Reporter |
As you can see the new column was based on taking the keyword "Reporter" from the Job title column and then putting that as a value on the Main Title column.
I know how to add a new column but not sure what functions I can use to populate the correct values in that column?
Any help would be much appreciated, thanks!
4 Replies
I would use a SWITCH(TRUE() statement and SEARCH or FIND
SWITCH(TRUE(),
SEARCH("Reporter",[Column]),"Reporter",
SEARCH("Something else",[Column]),"Booger",
"Some default value"
)
Thank you so much for your quick response.
When I selected to add a new column and then entered the below in the formula box it gave me below error:
Function 'SWITCH' does not support comparing values of type True/False with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.
Anonymous - OK, use this instead, sorry:
Column =SWITCH(TRUE(),SEARCH("Reporter",[Job Title],,-1)<>-1,"Reporter","Something else")
