Forum Discussion
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 ...
- Looks like you are missing a comma or semi-colon after the VAR next line.
Yes! I was missing the comma. BTW I just bought your book. Thanks for your help!
And is this a column you are creating? It should be a column and not a measure if I remember correctly.
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.
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.
- SpoilerI appreciate the PBIX file. You were right but it still doesn't work. Here is a screenshot:
- Looks like you are missing a comma or semi-colon after the VAR next line.