Forum Discussion

willpioli's avatar
willpioli
Frequent Visitor
9 years ago
Solved

Problem with DAX IF IN()

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" ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    willpioli

     

    hi, try using this DAX

     

    Test =
IF (
    Table1[Codcustomer] = 4433
        || Table1[Codcustomer] = 1740
        || Table1[Codcustomer] = 5808
        || Table1[Codcustomer] = 5685,
    "shopping",
    "market"
)
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    willpioli

     

    Try this:

     

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

willpioli's avatar
willpioli
Frequent Visitor
9 years ago

it worked -.-

 

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

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

willpioli

 

Try this:

 

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