Possible to make less verbose DAX?

[Anonymous]

IF( 
    OR(Table[Column] = "A", 
    OR(Table[Column] ="B", 
       Table[Column]="C")),
    "These are some letters", 
    IF( 
        OR(Table[Column]="Bill",
        OR(Table[Column]="Mary",
        OR(Table[Column]="Joe",
        OR(Table[Column]="Jeff",
           Table[Column]="Tony")))), 
       "These are names","Other" 
    )

It just seems kinda crazy that I have to say Table[Column] every time, maybe "OR" isn't the best option. Is there a better way to write this?

[Vvelarde]

@Anonymous

Hi, you can reduce the code using IN {}

Result =
SWITCH (
    TRUE (),
    Table1[Column] IN { "A", "B", "C" }, "These are some letters",
    Table1[Column] IN { "Bill", "Mary", "Joe", "Jeff", "Tony" }, "These are names",
    "Other"
)

Regards

Victor

Lima - Peru

[MFelix · Accepted solution]

Hi @Anonymous,

In dax there isn't an equivalent formula to the IN of SQL, please check this article with the explanation and how to do it in different number of ways.

Regards,

MFelix