Using SWITCH with IN

[Anonymous]

Hello Community    -    This is a new thread for the same topic.   Previously I was trying a different formula, but ultimately I think SWITCH might be better as I have two variable that I need to check  (different columns, but same table). 

First, I need to check if the Product Code fits a certain criteria.    Second, I need to check if the ITEM description contains (anywhere) the text  "-1".    

This formula below only works if I do not include the IN statements.    All I get returned is  "NA".      Just trying to figure out how to include the IN statment, or some other formula that gets to the result below. 

The goal would be to return this result, if the row item met the criteria.

Product Code          Item                              SKU Type

CODE123            AB-23-45-1-X               Standard SKUs

SKU Type =  SWITCH(

TRUE(),

'Flu_Shipped Query'[Product Code] = "CODE123" && 'Flu_Shipped Query'[Item] IN {"-1"}, "Standard SKUs",

'Flu_Shipped Query'[Product Code] = "CODE346" && 'Flu_Shipped Query'[Item] IN {"-1"}, "Standard SKUs",

'Flu_Shipped Query'[Product Code] = "CODE782" && 'Flu_Shipped Query'[Item] IN {"-1"}, "Standard SKUs",

"NA")

[vanessafvg]

have you checked your data? i have run this on some test data and your code works fine, maybe your data doesn't support your condition?

see attached

[Tahreem24 · Accepted solution]

@Anonymous ,

Try to use Search or Find DAX:

SKU Type =  SWITCH(

TRUE(),

'Flu_Shipped Query'[Product Code] = "CODE123" && SEARCH("-1",'Flu_Shipped Query'[Item]),"Standard SKUs",

 . . . )

Please complete your formula like above.

[Anonymous]

@Tahreem24     Thanks Tahreem, but I am getting the following error: 

The search Text provided to function 'SEARCH' could not be found in the given text

[Tahreem24]

@Anonymous ,

There is a simplied version of DAX. I've created same sample like you and also attached the screen shot below with DAX and expected output.

Hope it may help you.