Forum Discussion

AbhishekAejae's avatar
AbhishekAejae
Regular Visitor
2 years ago
Solved

DAX Support

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's avatar
    lbendlin
    2 years ago
    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"
)

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    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"
)