Problem with DAX IF IN()

[willpioli]

a simple sintaxe like this used to work.... i dont know its not working anymore after the few lastest updates 

Teste= IF (BaseFat2[Cod custumer] IN (4433;1740;5808;5685) ; "shopping";"market" )

the IN statment is not working anymore, i cant even use OR... and i dont want to use multiple if conditionals

Can someone help me to solve this or build a new formula??

[Vvelarde · Accepted solution]

@willpioli

hi, try using this DAX

Test =
IF (
    Table1[Codcustomer] = 4433
        || Table1[Codcustomer] = 1740
        || Table1[Codcustomer] = 5808
        || Table1[Codcustomer] = 5685,
    "shopping",
    "market"
)

[Vvelarde · Accepted solution]

@willpioli

hi, try using this DAX

Test =
IF (
    Table1[Codcustomer] = 4433
        || Table1[Codcustomer] = 1740
        || Table1[Codcustomer] = 5808
        || Table1[Codcustomer] = 5685,
    "shopping",
    "market"
)

[willpioli]

it worked -.-

do you know why " IF xxx IN (z,y,a,b)" stoped working?

[Vvelarde · Accepted solution]

@willpioli

Try this:

IF xxx IN {z,y,a,b}, "A","B"