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