topic Correct DAX syntax for using SWITCH and Contains together. in DAX Commands and Tips

Correct DAX syntax for using SWITCH and Contains together.

Anonymous — Sun, 04 Feb 2024 17:26:22 GMT

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.

Re: Correct DAX syntax for using SWITCH and Contains together.

Jihwan_Kim — Sun, 04 Feb 2024 17:59:41 GMT

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" )

Re: Correct DAX syntax for using SWITCH and Contains together.

Anonymous — Sun, 04 Feb 2024 18:50:42 GMT

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

Re: Correct DAX syntax for using SWITCH and Contains together.

Anonymous — Sun, 04 Feb 2024 19:22:02 GMT

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