Maintenance KPI - Calculating MTBF & MDT (Mean Time Between Failures & Mean Downtime) in Power BI

In this video, you'll learn how to calculate the MTBF (Mean Time Between Failures) and MDT (Mean Downtime) in Power BI. This is the first in a series of videos exploring the subject of reliability and availability calculations in Power BI. This video focuses on MTBF and MDT for a machine that is continually running. The data we have for the machines is a table of all the downtime events, both planned and unplanned (breakdowns). You'll learn how to create the calculated columns and measures required to calculate the MTBF and MDF. 👍Tip: This is a longer video so why not try increasing the playback speed to save time. Research has shown that this can speed up your learning! You'd be surprised how well it works! ---------------------------------- ⏩ Video Navigation ---------------------------------- 00:00 - Definitions 02:48 - Data Set and Model 04:05 - Building in Power BI - Shift Definition 06.38 - Downtime Event Length Calculated Column 10:10 - Action Running Time Measure 13:40 - Building up the calculations 14:25 - Number of unplanned downtime events 15:15 - MTFB (Hours) measure 16:10 - MDT (Hours) measure 18:45 - Summary of results ----------------------------------------------------- 🎥 Related Videos ----------------------------------------------------- Maintenance KPI - Calculating MTBF & MDT (Mean Time Between Failures and Mean Downtime) in Power BI https://youtu.be/PRVPyp0tmn8 Why You Need a 'Dates' Table in Power BI and How to Create One - https://youtu.be/exq8AVNCHTY ----------------------------------------------------- 🎓 Power BI Dashboard Training ----------------------------------------------------- 👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes! https://effectivedashboards.com/power-bi-quick-start-create-a-pbi-dashboard-in-90-minutes/ 👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that really do help you, your boss, and your peers make better decisions! https://effectivedashboards.com/power-bi-quick-start-plus/ ------------------------- 📁 Resources ------------------------- 👉Access to the source PBIX files for my YouTube videos: https://effectivedashboards.com/courses/free-resources/ 👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data). https://effectivedashboards.com/data-articles/