Forum Discussion
IF Function Combined
Dear Community I have a question: I want to use an "If" function but also need to filter by an specific status from another column ("Green", "Yellow" , "Red"), in this case "Red"... (all in the same...
If the search is with a single Column you can shorten the CODE by using the "IN" operator
=
IF (
'EXTR-INC&WO-(Chil'[Sta] IN { "Asigned", "In Progress" }
|| 'EXTR-INC&WO-(Chil'[Column] IN { "__", "__" },
1,
___
)