DAX Support

[AbhishekAejae]

I'm new to Power BI andlooking for help mentioned below,

In the below query, I have one more condition to be added in that which goes like,

Need to add this to the below query:

If Escalation Record Status = "Closed Deescalated and Closed Complete" and Parent Ticket State = "Open, Work In Progress, Pending, Assigned" then "Resolved" else "Created"

Existing Query:

Created & Resolved = switch(

    TRUE,

    [Parent Ticket State]="open"||[Parent Ticket State]="Work In Progress"||[Parent Ticket State]="pending"||[Parent Ticket State]="assigned","Created",

    [Escalation Record Status]="open"||[Escalation Record Status]="Work In Progress", "open", "Resolved"

)

Can anyone help me please?

[lbendlin · Accepted solution]

Created & Resolved = switch( TRUE(),
    [Escalation Record Status] IN {"Closed Deescalated","Closed Complete"} 
       && [Parent Ticket State] IN {"open","Work In Progress","pending","assigned"},"Resolved",
    [Parent Ticket State] IN {"open","Work In Progress","pending","assigned"},"Created",
    [Escalation Record Status] IN {"open","Work In Progress"}, "open", 
     "Created"
)