Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AbhishekAejae
New Member

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?
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.