Calculating service downtime based in incident total time excluding non operational hours

[Werick_V]

Hi

I am trying to find a way to calculate the total time a incident is affecting the availability of a service, but i aly want to cound the times the service is open during oerational hours.

there are different sites each with it own operational hours for weekdays, saturddyas and sundays.

Manually the results should look like this

I would apprciate some assitance.

Regards

[Anonymous]

Hi @Werick_V ,

please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data to help us clarify your scenario.

Best Regards,
Eyelyn Qin

[Thingsclump]

Hi @Werick_V 

At a high level, you can create table with list of all sites (Table A). Create one more table as a calender table which will have list of dates, day name, weekday or not etc. (Table B). Next is create a table with operational hours only. (Table C). Last table would be incidents table with downtime (Table D). Create relationship between Table A, C and D using site name. Table B, C, D should be related by date column. So create a relationship for it. 

The required view of operational hours-downtime can be calculated by a measure which you can use in any chart or visual.

Thanks

Thingsclump

 www.thingsclump.com