Greg_Deckler
Community Champion
7 years agoMean Time Between Failure (MTBF)
This Quick Measure is an update to my Mean Time Between Failure (MTBF) measure that I developed in this article:
https://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-P...
skai
2 years agoFrequent Visitor
This is really handy and would like to implement it in my model, however my data model is structured abit differently. I have a fact table (Notificatons) with notification data (notification, location id, breakdown status) and this is connected to a dimension table via "notificaiton" field showing the start and end times of the notifcation (lets call it MTBF table).
The fact table is connected to another dim table (location data) via location id and this contains the machine field. I am not sure how to determine the next_repair with this current model, any help will be much appreciated