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