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

QT#84 – 3 Ways ChatGPT Can Be Your Power BI Report Development Buddy

QT#82 – Improving the Design of a matrix visual HEAT MAP in Power BI

Power BI CARD with STATES by OKViz Deep Dive – Learn 3 Ways To Set Up This Great Card Visual

Add Metric Notes to Power BI Reports Pt2 – Using Power Automate to Refresh Scorecard Dataset
Author Image

About the author 

Jason Davidson

Jason Davidson is the founder of EffectiveDashboards.com. 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.

 Get Instant Access
>