Forum Discussion
sullynivek
8 years agoFrequent Visitor
Calculating 'mean time between failures'
Hi All, I am stuck on this problem, I need to calculate the MTBF of my companies assets. There are 2 dates in the table 'org_date' (origination date - this is when the job is created) and 'cm...
sullynivek
8 years agoFrequent Visitor
Hello,
Just an update to the above, I have now made some progress. I now get the correct result i.e. the mean time in days between breakdowns. But the table is not populated with each increment of days in between each record. The measure is as follows:
Mean Time Between Failures =
AVERAGEX (
wkaw,
VAR CurrentOrgDate = wkaw[org_date]
VAR CurrentNo = wkaw[Index]
VAR PreviousCompDate =
CALCULATE (
MAX ( wkaw[cmpl_date] ),
ALLEXCEPT( wkaw, wkaw[assetno] ), FILTER (wkaw,
CurrentOrgDate >= wkaw[cmpl_date] ), wkaw[Index] <> CurrentNo
)
RETURN
IF (
NOT ( ISBLANK ( PreviousCompDate ) ),
1
* ( CurrentOrgDate - PreviousCompDate )
)
)below you can see it provides the total MTBF: