Forum Discussion

sullynivek's avatar
sullynivek
Frequent Visitor
8 years ago

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...
Need Help
mattbrice's avatar
mattbrice
Solution Sage
8 years ago

Can you try this?

 

Mean Time Between Failures =
AVERAGEX (
    wkaw,
    VAR CurrentOrgDate = wkaw[org_date]
    VAR CurrentNo = wkaw[Index]
    VAR PreviousCompDate =
        CALCULATE (
            MAX ( wkaw[cmpl_date] ),
            FILTER (
                ALLEXCEPT ( wkaw, wkaw[assetshortdesc] ),
                wkaw[cmpl_date] <= CurrentOrgDate
                    && wkaw[Index] < CurrentNo
            )
        )
    RETURN
        IF (
            NOT ( ISBLANK ( PreviousCompDate ) ),
            1
                * ( CurrentOrgDate - PreviousCompDate )
        )
)
  • sullynivek's avatar
    sullynivek
    Frequent Visitor
    8 years ago

    mattbrice - i tried what you suggested, but it gave me the same result.