Conditional formatting

[Anonymous]

I am trying to use "Switch" to return values but cannot work out how to used the "Or" funtion within the DAX

Response SLA Met =

SWITCH(

TRUE(),

Incidents[Priority] = "Critical", AND (Incidents[Respond Time Hrs] <1.5, "True"

))

Works as expected BUT i also need to use Or to complete the required outcome

Incidents[Priority] = "High", AND (Incidents[Respond Time Hrs] <3.0, "True"

Any advise would be appreciated

Gary Gray

[jennratten · Accepted solution]

In switch statemetns you can include AND critiera like this && and OR criteria like thisYou can include AND criteria OR criteria in your switch statement like this ||.

Response SLA Met =
SWITCH(
TRUE(),
-- Priority = Critical and Respond Time Hrs < 1.5
Incidents[Priority] = "Critical" && (Incidents[Respond Time Hrs] <1.5, "True",
-- Priority = Critical or Respond Time Hrs < 1.5
Incidents[Priority] = "Critical" || (Incidents[Respond Time Hrs] <1.5, "True",
"False"
)