Spread period over hours

[jackvandeven]

Hello,

I tried searching but couldn't find my problem & solution. If you have link please.

What I want to achieve is the following:

I have CI's wich are up 24X7 except when there is an isue. The isue is booked as. "CI", "start date&time" and "End date&time". Now my client wants to recieve an overview of the uptime per hour in minute. Something like this:

Suppose CI#1 has no downtime on 10-1

               CI#2 has downtime on 10-1 from 2:45 till 5:30

               0   1   2   3   4   5  6   7    8  9           ...              22  23    Total

Date: 10-1

  CI #1   60 60 60 60 60 60 60 60 60 60           ...             60  60   1440

  CI #2   60 60 45  0   0  30 60 60 60 60           ...             60  60   1275

Date: 10-2

What would the ideal method be to convert a period to downtime per hour?

Thanks,

Jack

[v-cherch-msft]

Hi @jackvandeven

Could you share some data sample and expected output? Below is the data i guessed and measures used in Matrix visual.

C1# = ABS(60-SUM(Table3[C1]))

C2# = ABS(60-SUM(Table3[C2]))

Regards,

Cherie

[Greg_Deckler]

Not entirely sure because I don't really understand your source data format, but these might help:

That being said, take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...