Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX query for SLA tacking

Due dateStatusTask_statusSLA
13/10/2022HistoryTask CompletedPass
13/10/2022HistoryWork in progressFail
13/10/2022CancelledAssignedFail
20/10/2022 AssingedFailed

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"

DAX
powerbi
  • Anonymous's avatar
    Anonymous
    3 years ago
    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"
    )
)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago
    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"
    )
)