Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |