Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to Solution.
@Anonymous , Create a new column like
Switch( true(),
search( "Marriott" ,[Hotel],,0)>0,"Marriott",
search( "Hilton " ,[Hotel],,0)>0,"Hilton ",
"Other"
)
@Anonymous , Create a new column like
Switch( true(),
search( "Marriott" ,[Hotel],,0)>0,"Marriott",
search( "Hilton " ,[Hotel],,0)>0,"Hilton ",
"Other"
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |