Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Calculating Mean Time Between Failure

@Amit, @Greg , @tamerj1 , @lbendlin    @amitchandak , @olgad , @Sahir_Maharaj , @FreemanZ , @tamerj1 , @Greg_Deckler    @christinepayton @audreygerred    LukeB,   Hello PowerBI expert folks, ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello lbendlin ,

 

This is way too complicated. I don't even use the M-Query or the Advanced Editor. Can you suggest a DAX formula for this?

 

Thanks,

lbendlin's avatar
lbendlin
Super User
2 years ago

MTBF DAX = 
var b = MAXX(OFFSET(-1,ALL('Table'),PARTITIONBY([Equipment]),MATCHBY([BreakDownDate])),[BreakDownDate])
Return if(not ISBLANK(b),[BreakDownDate]-b)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello lbendlin 

     

    The code above is not working--It is giving error like below:

     

     

    The error is mainly in regards to using PARTITIONBY and MATCHBY Commands. Do I need to write 'Table'[Equipment] since Table is a data table and Equipment is a column variable inside of that data table? Can you please suggest a better working code. 

     

    Thanks,

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Sounds like you are running a rather old version of Power BI Desktop?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hello lbendlin,

        The PowerBI desktop I am using is February 2023 version. Is my PowerBI old enough for this formula to not work?