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"

Vvelarde's avatar
Vvelarde
Community Champion
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"
)
  • 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"