Maintenance KPI – MTBF, MDT & % Availability In Power BI Scenario 2 – Duty / Standby Machines

In this video, I'll explain how to calculate availability %, MTBF, and MDT in Power BI when you have 2 machines. One is running while the other is on standby. This is also known as a duty/standby configuration.

I'll spend some time talking through the scenario. Then go on to cover the data that you need to collect to be able to calculate each of these measures in Power BI.

Finally, we'll move into Power BI and create the measures you need to create the metrics.

Download the file used in this video in my YouTube Video File section of my free resources page

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