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
   • Maintenance KPI  % Availability and ...  

Why You Need a 'Dates' Table in Power BI and How to Create One    • QT#9  Why You Need a 'Dates' Table i...  


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...

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...


Resources

Access to the source PBIX files for my YouTube videos:
https://effectivedashboards.com/cours...

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...