Nest If Statement with Text/String Variable

Question

Hello All,&nbsp;&nbsp;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.&nbsp; (apologize if my terms are inncorrect).&nbsp;&nbsp;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.&nbsp;HotelChannelMarriott OhioMarriottCourtyard by MarriottMarriottHilton NYHiltonMotel 6OtherHilton CAHilton&nbsp;&nbsp;Thank you for your help!&nbsp;&nbsp;&nbsp;

amitchandak · Accepted Answer

Anonymous , Create a new column like 
Switch( true(),search( "Marriott" ,[Hotel],,0)&gt;0,"Marriott",search( "Hilton " ,[Hotel],,0)&gt;0,"Hilton ","Other")

Forum Discussion

Nest If Statement with Text/String Variable

2 Replies

Related content

exact text string patter test

Creating a bookmark with long text strings

Extract part of text string

Variables in if statement

Remove text string based on given text string from the list

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