If contains a specific group of words for a column then

[cristianml]

I need to get a way to find a specific group of words for a column cause interferes with other text:

Example: I need to get SC for STRATEGY CONSULTING from VAR5 instead of CON that also have the word Consulting in VAR3 : 

As you see the problem is that both have CONSULTING and the CONTAINSTRING considers the VAR3 instead to consider V5

SG =

VAR V1 = CONTAINSSTRING('_List SG'[Service Group],"APPLICATION OUTSOURCING")

VAR V2 = CONTAINSSTRING('_List SG'[Service Group],"BUSINESS PROCESS OUTSOURCING")

VAR V3 = CONTAINSSTRING('_List SG'[Service Group],"CONSULTING")

VAR V4 = CONTAINSSTRING('_List SG'[Service Group],"INFRASTRUCTURE OUTSOURCING")

VAR V5 = CONTAINSSTRING('_List SG'[Service Group],"STRATEGY CONSULTING")

VAR V6 = CONTAINSSTRING('_List SG'[Service Group],"SYSTEMS INTEGRATION")

RETURN

IF(V1,"AO",

IF(V2,"BPO",

IF(V3,"CON",

IF(V4,"IO",

IF(V5,"SC",

IF(V6,"SI",

"Other"))))))

What other way can I use in this case to get the result for a specific sentence or group of words ?

Thanks !

[PhilipTreacy · Accepted solution]

Hi @cristianml 

Don't use CONTAINSSTRING, use = e.g.

VAR V3 = IF ( '_List SG'[Service Group] = "CONSULTING", True, False)

VAR V5 = IF ( '_List SG'[Service Group] = "STRATEGY CONSULTING", True, False)

Regards

Phil