DAX query for SLA tacking

[Anonymous]

Due date	Status	Task_status	SLA
13/10/2022	History	Task Completed	Pass
13/10/2022	History	Work in progress	Fail
13/10/2022	Cancelled	Assigned	Fail
20/10/2022		Assinged	Failed

I want to write Dax query to track if SLA was missed. If task due date is in past and Task status is "Cancelled" or "Task Completed" SLA miss should say "Pass" Else say "Fail". If date is in future SLA miss should say "on track"

[Anonymous · Accepted solution]

SLA Status = 
IF(
    Task_data[Task_due_date] >= TODAY(),
    "On track",
    IF(
        OR(
            Task_data[Task_Status] = "Task Completed",
            Task_data[Task_Status] = "Cancelled"
        ),
        "Complete",
        "Breached"
    )
)