Nest If Statement with Text/String Variable

[Anonymous]

Hello All, 

I am new too Power Bi, and I am having issues finding out how to do a nested if statment. Which the variable is searching for part of the text/String.  (apologize if my terms are inncorrect). 

I would like to do an if statment to configure hotel channels (chain). Such as all that have Marriott in the name, to be labled as Marriott, Hiltons as hiltons, and eventually all others as "Other". Is there a way to do this? Below is a table example as reference.

Hotel	Channel
Marriott Ohio	Marriott
Courtyard by Marriott	Marriott
Hilton NY	Hilton
Motel 6	Other
Hilton CA	Hilton

Thank you for your help!

[amitchandak · Accepted solution]

@Anonymous , Create a new column like

Switch( true(),
search( "Marriott" ,[Hotel],,0)>0,"Marriott",
search( "Hilton " ,[Hotel],,0)>0,"Hilton ",
"Other"
)

[Anonymous]

Thank you that worked Perfect! @amitchandak