Service Level Agreement (SLA) calculation

[Azucrinador]

Dears, good afternoon!

I'm having a bit of trouble getting to a result of SLA, in this matter, i want to calculate the SLA percentage of a period in which the service was unavailable.

Example: The service is meant to be running 100% of the time, and when it has a failure (calculated in minutes), it will deduct of it's total SLA. I was able to get the SLA based on 30 days only, with the formula (SLA = ((SUM('Plan1'[TEMPO ABERTO])-43200)/43200)*-1). TEMPO ABERTO = running time. 

Below is an example of how it is being viewed.

I can reach the desired SLA but only determining that it has to be calculated in 28, 30 or 31 days.

Is there any way I can perform it to calculate it by month? Like, if the ticket was opened in October, having 22 minutes of failure, it will be the sum of TEMPO ABERTO (unavailable time), minus 44.640 minutes (31 days), divided by 44.640 (31 days).

Thanks!

[v-yueyunzh-msft]

Hi , @Azucrinador 

Do you mean you want to get the minutes accoding to the Month ?

If this , you can define a parameter to get the minutes, you can use this to get how many days in this month:

DAY(EOMONTH('Table'[Date],0)) 

Then you can get how many minutes in this month.

Best Regards,

Aniya Zhang

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