Forum Discussion
Problems with MTBF calculations
- 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!
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.
Yes! I was missing the comma. BTW I just bought your book. Thanks for your help!
Not to be that guy, but the code in the PBIX file I sent certainly works.