Forum Discussion

rbartlejr's avatar
rbartlejr
Helper III
6 years ago
Solved

Problems with MTBF calculations

I've been trying to emulate the MTBF calculations in this blog post: https://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586. I'm having problems with ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Looks like you are missing a comma or semi-colon after the VAR next line.
  • rbartlejr's avatar
    rbartlejr
    6 years ago

    Yes! I was missing the comma. BTW I just bought your book. Thanks for your help!

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
Sounds like you need to change the commas to semi-colons ( ; ). Regional language settings.
rbartlejr's avatar
rbartlejr
Helper III
6 years ago

Greg_Deckler Ok, I tried that and get this error: EARLIER/EARLIEST refers to an earlier row context which doesn't exist. I looked in the data and there are more than one asset #s in several rows.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    And is this a column you are creating? It should be a column and not a measure if I remember correctly.
    • rbartlejr's avatar
      rbartlejr
      Helper III
      6 years ago

      It shows in the blog article as a measure; the data is set into columns for date, asset #, etc. I can calculate a column for the repair time (already done) since the Repair Hours measure didn't work either.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        6 years ago

        Here is the original PBIX attached below if it helps.

         

        I checked and Uptime is a calculated column. Also, read through the comments as I think there were some bugs/issues that were hammered out that I eventually included in my book DAX Cookbook. The book now has the best version of this. I can take a look at that and see if it helps. Let me know.