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 help me?
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")

5 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    Use this

    = IF('Query6'[TICKET_STATE] = "NEW" || 'Query6'[TICKET_STATE] = "OPEN", "COMPLETED", "REJECTED")
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

      • Vijay_A_Verma's avatar
        Vijay_A_Verma
        Most Valuable Professional
        4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Done. Sorry for the mistake.

  • 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" )