topic Re: DAX switch but using containsstring in DAX Commands and Tips

DAX switch but using containsstring

JK-1 — Thu, 21 Aug 2025 23:29:52 GMT

Is there a way to have CONTAINSSTRING in the below instead, as using IN as part of the VAR _Name requires an exact, and I have some examples elsewhere where it would be easier to use containsstring. I've tried a few different IF CONTAINSSTRING in places, and substituted TRUE but can't get it to work

Result = VAR _Name = 'Table1'[Name]
RETURN
SWITCH(
TRUE(),
_Name IN {"South"},
"30",
_Name IN {"North"},
"28",
_Name IN {"East"},
"22",
_Name IN {"West"},
"20",
""
)

thanks in advance

Re: DAX switch but using containsstring

Shahid12523 — Fri, 22 Aug 2025 02:42:13 GMT

Yes — replace IN with CONTAINSSTRING inside SWITCH(TRUE())

Result =
VAR _Name = 'Table1'[Name]
RETURN
SWITCH(
TRUE(),
CONTAINSSTRING(_Name, "South"), "30",
CONTAINSSTRING(_Name, "North"), "28",
CONTAINSSTRING(_Name, "East"), "22",
CONTAINSSTRING(_Name, "West"), "20",
""
)

Re: DAX switch but using containsstring

Anonymous — Fri, 22 Aug 2025 10:18:29 GMT

Hi JK-1 ,

Did you get a chance to try the Shahid12523 suggestion with CONTAINSSTRING inside SWITCH(TRUE())? It should work as expected for example, "South Region" would correctly return 30. Just note that if a name contains more than one of the keywords (like "NorthEast"), the formula will stop at the first match it finds, so only "North" would be applied in that case. Otherwise, the approach should give you the results you’re looking for.

Regards,
Akhil.