Forum Discussion

Azucrinador's avatar
Azucrinador
Regular Visitor
3 years ago

Calculating availability

Hi! I'm trying to calculate the availability of service on DAX, I was able to do it by adding the running time (minutes), deducting 43200 and dividing by 43200 (30 days). It gives me the availabilit...
amitchandak's avatar
amitchandak
Super User
3 years ago

Azucrinador ,

In any Date you can add minutes like

 

[Date] + Time(0,[Minutes column], 0)

 

but can you explain this

Is there any way I can get the sum of the running time (in minutes), deduct the accordingly month time (in minutes) and divide by it?

 

In case you days in month

day(eomonth([Date],0))  will give last day of month

  • Azucrinador's avatar
    Azucrinador
    Regular Visitor
    3 years ago

    Hi Amitchandak, thank you for the reply, here is a sample of what I've already done which gives me the availability time within 30 days,

    Here is the formula used "

    SLA = ((SUM(Enel[TEMPO ABERTO])-43200)/43200)*-1" Tempo aberto = The period the service was having a failure.

    In my case, we assume that the service should be running 24/7, and we deduct the time it had a failure (in minutes) to get the service availability, example below:

    This is the information I get by using the formula, which gives me the availability for 30 days, but I need to be able to make it calculate month by month, like, February has 28 days, so the availability will be calculated in this period. 

    Can it be done in a single formula?