Forum Discussion

Cypher294's avatar
Cypher294
Frequent Visitor
8 years ago
Solved

Priority Based SLA Calculation

HI,   I've got a question about a combined statement   In my source data we have the ticket information "priority" and runtime in hours. Now I've want to create a statement about a SLA breach st...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Cypher294,

     

    Suppose you have such a table to list SLA values.

     

    Then, in data table, create a calculated column.

    SLA STATE =
IF (
    Table_1[Ticket Runtime in hours]
        >= LOOKUPVALUE ( Table_2[Runtime], Table_2[Proority], Table_1[Priority] ),
    "SLA Violated",
    "SLA OK"
)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Cypher294,

 

Suppose you have such a table to list SLA values.

 

Then, in data table, create a calculated column.

SLA STATE =
IF (
    Table_1[Ticket Runtime in hours]
        >= LOOKUPVALUE ( Table_2[Runtime], Table_2[Proority], Table_1[Priority] ),
    "SLA Violated",
    "SLA OK"
)

 

Best regards,

Yuliana Gu

  • Cypher294's avatar
    Cypher294
    Frequent Visitor
    8 years ago

    Thank You :-)