Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX query for SLA tacking

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