Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Jeyeline
Helper III
Helper III

Mean Time Between Failure for an application

Hello Everyone,

 

 I have a data model which contains fields such as:
Incident Title, Created on, Resolved on, Closed on whose sample list is represented below:

Incident TitleCreated onResolved onClosed on
Application DownJan 1, 2025Jan 5, 2025Jan 7, 2025
DB IssueJan 4, 2025Jan 5, 2025Jan 9, 2025
API IssueJan 9, 2025Jan 10, 2025Jan 10,2025

Now, I would like to calculate the meantime between failure for this application. How could that be done?

2 ACCEPTED SOLUTIONS
rajendraongole1
Super User
Super User

Hi @Jeyeline  - you need to determine the average time between the resolution of one incident and the creation of the next incident.

create a calculated column for difference time

 

Time Between Failures =
DATEDIFF(
'Incidents'[Resolved on],
CALCULATE(
MIN('Incidents'[Created on]),
FILTER(
'Incidents',
'Incidents'[Created on] > EARLIER('Incidents'[Resolved on])
)
),
DAY
)

 

Once you have the Time Between Failures column, create a measure to calculate the MTBF by averaging these time differences.

MTBF =
AVERAGE('Incidents'[Time Between Failures])

 

Few reference links:

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

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

Greg_Deckler
Super User
Super User

@Jeyeline See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395....
The basic pattern is:
Column = 
  VAR __Current = [Value]
  VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])

  VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
 ( __Current - __Previous ) * 1.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@Jeyeline See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395....
The basic pattern is:
Column = 
  VAR __Current = [Value]
  VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])

  VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
 ( __Current - __Previous ) * 1.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
rajendraongole1
Super User
Super User

Hi @Jeyeline  - you need to determine the average time between the resolution of one incident and the creation of the next incident.

create a calculated column for difference time

 

Time Between Failures =
DATEDIFF(
'Incidents'[Resolved on],
CALCULATE(
MIN('Incidents'[Created on]),
FILTER(
'Incidents',
'Incidents'[Created on] > EARLIER('Incidents'[Resolved on])
)
),
DAY
)

 

Once you have the Time Between Failures column, create a measure to calculate the MTBF by averaging these time differences.

MTBF =
AVERAGE('Incidents'[Time Between Failures])

 

Few reference links:

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

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.