cancel
Showing results for
Did you mean:
Visitor

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

2 REPLIES 2
Super User

## Re: Spread period over hours

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

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Super Contributor

## Re: Spread period over hours

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 78 members 1,418 guests
Recent signins: