Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to calculate total downtime of machine by machine status. if i select any machine name it has to show the total downtime of taht machine accordingly for example in the form of 1(day):23:5:5. Can anyone tell what should i do to calculate the downtime.
Solved! Go to Solution.
Take a look at my article on MTBF. I think that it will greatly assist you. Also, take a look at my article on aggregating duration.
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
I think there is also a quick measure or two in the Gallery related to duration.
Take a look at my article on MTBF. I think that it will greatly assist you. Also, take a look at my article on aggregating duration.
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
I think there is also a quick measure or two in the Gallery related to duration.
How can this be extended to report the line (with multiple equipment) and area(with multiple lines) Uptimes. For example:
Serial line : If a line has 4 machines , the lowest of the 4 should be the line Uptime
Parallel line : all 4 equipment running in parallel : Average of all 4 machines should be line Uptime
Since the filter context for a unit would be only for taht unit , the line and area uptimes would be same as equipment uptime...any help would be appreaciated
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |