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.
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
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |