Correct DAX syntax for using SWITCH and Contains together.

[Anonymous]

Hi All, 

New to the forum and Power Bi.  I am currently trying to figure out how to classify various codes to Products in my query.  The trick is that some codes are utilized expressly for a given product while for others variations are used. A nested IF may be a possibility, but I am currently trying to use SWITCH in conjunction with "Contains" for the cases where a variation of the code is being used.  Here is an excerpt on how i currently have the DAX formula set up:

SWITCH(TRUE(),

'Code Load'[Billing ID]="ESEAT3", "Seats",

'Code Load'[Billing ID]Contains "EECI", "Superior Svc"

I am currently getting an error on synatax for "Contains".  Any insight would be appreciated.  Thanks all.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

CONTAINSSTRING function (DAX) - DAX | Microsoft Learn

Expected result CC = 
SWITCH (
    TRUE (),
    'Code Load'[Billing ID] = "ESEAT3", "Seats",
    CONTAINSSTRING ( 'Code Load'[Billing ID], "EECI" ), "Superior Svc"
)

[Anonymous · Accepted solution]

Disregard my earlier send re useing CONTAINS in a nested statement.  Your solution works PERFECTLY.  Thanks for the quick response!!!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

CONTAINSSTRING function (DAX) - DAX | Microsoft Learn

Expected result CC = 
SWITCH (
    TRUE (),
    'Code Load'[Billing ID] = "ESEAT3", "Seats",
    CONTAINSSTRING ( 'Code Load'[Billing ID], "EECI" ), "Superior Svc"
)

[Anonymous]

This looks very good.  Question, how do i next the CONTAINSSTRING to utilize with multiple codes?  Thanks.