Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

IF OR DAX statement giving error

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 ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use this

    = IF('Query6'[TICKET_STATE] = "NEW" || 'Query6'[TICKET_STATE] = "OPEN", "COMPLETED", "REJECTED")
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

This can also be written like this:

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