Forum Discussion

rbartlejr's avatar
rbartlejr
Icon for Helper III rankHelper 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
Icon for Community Champion rankCommunity Champion
6 years ago
Sounds like you need to change the commas to semi-colons ( ; ). Regional language settings.
  • rbartlejr's avatar
    rbartlejr
    Icon for Helper III rankHelper 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
      Icon for Community Champion rankCommunity 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
        Icon for Helper III rankHelper 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.