IF OR DAX statement giving error

[Anonymous]

I wrote the below DAX statement but it is showing me error "

" My DAX statement is : 

Column 3 = IF('Query6'[TICKET_STATE] = "NEW" || "OPEN", "COMPLETED", "REJECTED")

Can someone please help me?

[AlexisOlson]

This can also be written like this:

IF ( 'Query6'[TICKET_STATE] IN { "NEW", "OPEN" }, "COMPLETED", "REJECTED" )

[Vijay_A_Verma · Accepted solution]

Use this

= IF('Query6'[TICKET_STATE] = "NEW" || 'Query6'[TICKET_STATE] = "OPEN", "COMPLETED", "REJECTED")

[Anonymous]

Done. Sorry for the mistake.

[Anonymous]

Thank you for your help. It worked for me. 🙂

[Vijay_A_Verma]

You marked wrong post as answer. Could you please correct it?