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.

Download the PBIX files for this video in my Free Resources section.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Recent Posts

About the author 

Jason Davidson

Jason Davidson is the founder of He is a maintenance and reliability engineer who uses Power BI every day to create dashboards that help him and others make better decisions. In his spare time, he likes running and has recently got into photography. He also loves spending time hanging out and larking about with his two daughters.

FREE Power BI Quick Start Course

Learn how to build a Power BI dashboard in under 90 minutes.