Forum Discussion
How to flag multiple items in a column using a calculated column
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
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)You could change all your && to || but I'd suggest the following instead:
IF ( 'Table'[Column] IN { "X", "Y", "Z", "A", "B" }, "1", "0" )
2 Replies
You could change all your && to || but I'd suggest the following instead:
IF ( 'Table'[Column] IN { "X", "Y", "Z", "A", "B" }, "1", "0" )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)