Forum Discussion
Correct syntax for IN
CAn somebody help me with the correct syntax for:
NonCompliance Day = IF('QGenda Compliance'[ClockOutCategory] IN ("Excessive duration/fixed clock in", "Missing clock out"), 1, 0)
Anonymous - Try:
NonCompliance Day = IF('QGenda Compliance'[ClockOutCategory] IN {"Excessive duration/fixed clock in", "Missing clock out"}, 1, 0)Hi Anonymous ,
Replace round brackets by Curly brackets for IN operator.
Syntax: IN {"Value1", "Value2",..,"Value N"}
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
3 Replies
Anonymous - Try:
NonCompliance Day = IF('QGenda Compliance'[ClockOutCategory] IN {"Excessive duration/fixed clock in", "Missing clock out"}, 1, 0)Hi Anonymous ,
Replace round brackets by Curly brackets for IN operator.
Syntax: IN {"Value1", "Value2",..,"Value N"}
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!