Forum Discussion
Correct DAX syntax for using SWITCH and Contains together.
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.
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" )
3 Replies
- Jihwan_Kim
Super User
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" )