cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jackvandeven Visitor
Visitor

Spread period over hours

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

v-cherch-msft Super Contributor
Super Contributor

Re: Spread period over hours

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]))

2.png

 

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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

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

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

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.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

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

Users Online
Currently online: 78 members 1,418 guests
Please welcome our newest community members: