Forum Discussion
PowerBI Desktop
Hello lbendlin ,
I am not sure how are you getting MTBF for Equipment A as 30.5 days and Equipment B as 24.50 days. Because, Equipment A has failed 3 times and the total operating time is 30+61+91 = 182 days, No of times it has failed = 3, So, MTBF should be 60.67 for Equipment A.
Similarly, For Equipment B, the total operating time is 62+93+111 = 266 days and it also failed 3 times, so the MTBF for Equipment B should be 88.67 days.
Can you please tell me your logic here?
Thanks.
I guess you and I have a different understanding of what MTBF means.
Equipment A has failed three times. That means it had two "times between failure". MTBF can be computed by averaging each individual "time between failure" or - simpler - by dividing the time from the earliest failure to the latest failure by two, resulting in 30.5 . The "total operating time" has no influence on the MTBF calculation.
Hello lbendlin
Total Operating Time has direct relationship with Mean Time Between Failure. MTBF is the Total Operating Time/Number of Failures.
Also, in the sample dataset, Equipment A has failed 3 times. Equipment B has also failed 3 times. So, the Number of Failures is equivalent to 3.
Please refer to the snapshot above. And we are trying to capture this in our DAX code. Can you please suggest an appropriate DAX code?
Thanks.