SEARCH and SWITCH Data type issues

[rush]

Hi 

I need help trying to search for a text in a column and bring back a value due to the error below:

Function 'SWITCH' does not support comparing values of type True/False with values of type Text.

Your help is much appreciated.

Client =
SWITCH( TRUE(),
SEARCH("Apple", 'Billing and GP'[Project Name], 1 , 0) = 1  , "Apple", 'Billing and GP'[Client Name] ,
SEARCH("Pear", 'Billing and GP'[Project Name], 1 , 0) = 1, "Pear", 'Billing and GP'[Client Name],
'Billing and GP'[Client Name] 

[jdbuchanan71 · Accepted solution]

@rush 

Try it withouth the second text string.  You just need the TRUE part on each line of the SWITCH

Client = 
SWITCH( TRUE(),
SEARCH("Apple", 'Billing and GP'[Project Name], 1 , 0) = 1 , "Apple",
SEARCH("Pear", 'Billing and GP'[Project Name], 1 , 0) = 1, "Pear",
'Billing and GP'[Client Name] 
)

[jdbuchanan71 · Accepted solution]

@rush 

Try it withouth the second text string.  You just need the TRUE part on each line of the SWITCH

Client = 
SWITCH( TRUE(),
SEARCH("Apple", 'Billing and GP'[Project Name], 1 , 0) = 1 , "Apple",
SEARCH("Pear", 'Billing and GP'[Project Name], 1 , 0) = 1, "Pear",
'Billing and GP'[Client Name] 
)

[rush]

@jdbuchanan71 , thank you very much. It works well. 🙏

[jdbuchanan71 · Accepted solution]

@rush 

I think you would be better off using CONTAINSSTRING.  That way it will looking the whole string, not just the start and you can simplify it a bit:

Client = 
SWITCH( TRUE(),
    CONTAINSSTRING('Billing and GP'[Project Name],"Apple"),"Apple",
    CONTAINSSTRING('Billing and GP'[Project Name],"Pear"),"Pear",
    'Billing and GP'[Client Name]
)

[rush]

@jdbuchanan71 Thank you. This is better. Much appreciated. 🙏