Correct syntax for IN

[Anonymous]

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)

[Greg_Deckler · Accepted solution]

@Anonymous - Try:

NonCompliance Day = IF('QGenda Compliance'[ClockOutCategory] IN {"Excessive duration/fixed clock in", "Missing clock out"}, 1, 0)

[Anonymous]

Thank you!! Didn't realize it was something so simple.

[Anand24 · Accepted solution]

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 !!!

[Greg_Deckler · Accepted solution]

@Anonymous - Try:

NonCompliance Day = IF('QGenda Compliance'[ClockOutCategory] IN {"Excessive duration/fixed clock in", "Missing clock out"}, 1, 0)