Priority Based SLA Calculation

[Cypher294]

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 status.

In my example the SLA values would be

Priority Very High - 4 Hours

Priorty High - 6 Hours

Priority Medium - 10 hours

Priority Low - 20 hours

Depending on the value of " Ticket runtime in hours" and the "priority" of the ticket the Column " SLA State" needs to be set to " SLA OK" or "SLA Violated" if the " Ticket Runtime in hours" is equal or higher then the values explained before the state needs to be set to " SLA Violated" otherwise it needs to be set to " SLA OK.

Thanks for help

[v-yulgu-msft · Accepted solution]

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]

Thank You 🙂