IF calculation where IF dimension contains Text then Text (with ELSEIF conditions)

[AlexG16261626]

Hello!

I’m a Tableau user switching over to Power BI/DAX. I’m trying to replicate a Tableau calculation I had but having trouble figuring out the best approach in Power BI/Query. I am looking for an IF Contains THEN formula for multiple instances...

Here is the calculation in Tableau:

IF CONTAINS ([Campaign Name], “XYZ”) Then “XYZ Campaign”
ELSEIF CONTAINS ([Campaign Name], “ABC”) Then “ABC Campaign”
ELSEIF CONTAINS ([Campaign Name], “JKL”) Then “JKL Campaign”
END 

Thanks!

[vapid128 · Accepted solution]

Switch(true(),
CONTAINS ([Campaign Name], “XYZ”) ,“XYZ Campaign”
CONTAINS ([Campaign Name], “ABC”) ,“ABC Campaign”
CONTAINS ([Campaign Name], “JKL”) ,“JKL Campaign”
"ELSE"
)