Forum Discussion
PowerBI Desktop
Hello lbendlin
Can you please suggest this formula in PowerBI DAX instead of M-Query?
I don't understand M-Query that much. Plus, its a very hard programming language.
Thank you!
Super User
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.
- lbendlin
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.
Hello lbendlin ,
This is very helpful! This algorithm is yielding correct results for the MTBF for individual Equipments when I am using the Stacked Column Chart like this:
But I am trying to get the MTBF for all the Equipments for each month- January, February, March, etc..If I put the MTBF on the Y-axis, BreakDate on the X-axis and Legend = Equipment, I get the MTBF for the individual equipments but not as a whole for all the Equipments.
If I add the MTBF for all those individual Equipments, I am getting MTBF like 150, 200 for respective months whereas I am expecting value anywhere between 10-20 days.
How do I get the MTBF for all those necessary Equipments for each respective months?
Thanks
Hello lbendlin ,
Adding to this question, I can neither write a Measure nor a Calculated Column inside of that table using Average Function for the MTBF33. Also, PowerBI also does not allow me to select SUM, AVERAGE, MIN, MAX dropdown from the MTBF33 shown in the visual above in the Y-axis.
I think applying average for the MTBF for all those individual equipments for each of the respective month will solve this problem but I don't know how to go about solving it?
Thanks
- lbendlin
How do I get the MTBF for all those necessary Equipments for each respective months?I have no idea how this would logically even be possible.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.