Forum Discussion

taspland's avatar
taspland
Frequent Visitor
5 years ago
Solved

SLA Calculation

Hi, i'm trying to get a correct SLA state however i'm unable to get the data to show correctly. and have no idea how to split the incident and task sla on  I have a table with Ticket ID, Ticket Typ...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, taspland 

    I’ve downloaded your pbix file and I can roughly understand your requirement according to your description, you can try this calculated column:

    SLA STATE =

VAR _incidentsla=RELATED(SLA[incident sla])

VAR _tasksla=RELATED(SLA[Task SLA])

Return

IF(

    [ticket type]="Incident",

    IF(

        [business_duration]>=_incidentsla,

        "SLA Violated","SLA OK"),

        IF(

        [business_duration]>=_tasksla,

        "SLA Violated","SLA OK")

)

    The output is like this:

     

    And you can get what you want.

    You can download my test pbix file below

     

    If you still have a problem, you can explain your expected result in detail with examples.

    How to Get Your Question Answered Quickly 

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.