Forum Discussion
rbartlejr
Helper III
6 years agoProblems 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 ...
- 6 years agoLooks like you are missing a comma or semi-colon after the VAR next line.
- 6 years ago
Yes! I was missing the comma. BTW I just bought your book. Thanks for your help!
Greg_Deckler
Community Champion
6 years agoHere 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.
rbartlejr
Helper III
6 years agoSpoiler
I appreciate the PBIX file. You were right but it still doesn't work. Here is a screenshot:
- Greg_Deckler6 years ago
Community Champion
Looks like you are missing a comma or semi-colon after the VAR next line.- rbartlejr6 years ago
Helper III
Yes! I was missing the comma. BTW I just bought your book. Thanks for your help!
- Greg_Deckler6 years ago
Community Champion
Not to be that guy, but the code in the PBIX file I sent certainly works.