How to flag multiple items in a column using a calculated column

[Antonio195754]

Hi i have a column that has several data points, 25 different "reasons", in the column.  I'm trying to flag only 5 of those "reasons" but not sure how to do that.  I can do it with an IF statement/&&, but that's only going to return if they all meet the condition, i'm looking for an OR statement probably to make this work

Case Reason Flag = IF ( ('Table'[Column]) = "X" && 'Table'[Column] ="Y" && 'Table'[Column]= "Z" && 'Table'[Column] = "A" && 'Table'[Column] = "B", "1" , "0")

[bcdobbs · Accepted solution]

You could do it with the same IF but use || for or.

Alternatively try SWITCH...

SWITCH(
          TRUE(),
          Table[Col1]<1,1,
          Table[Col2] = 5, 1,
          0)

[AlexisOlson · Accepted solution]

You could change all your && to || but I'd suggest the following instead:

IF (
    'Table'[Column] IN { "X", "Y", "Z", "A", "B" },
    "1",
    "0"
)

[bcdobbs · Accepted solution]

You could do it with the same IF but use || for or.

Alternatively try SWITCH...

SWITCH(
          TRUE(),
          Table[Col1]<1,1,
          Table[Col2] = 5, 1,
          0)