Forum Discussion
Calculating Mean Time Between Failure
Hello lbendlin ,
Can you please include your idea in my DAX code-Not sure how to write that inside of my DAX code?
Thanks
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hello lbendlin ,
I have attached the sample file. Please let me know how you would implement your code in this sample data or if you have any other questions.
Thanks
Equipment BreakDownDate Index Halt-F16 01/05/2023 3:39:00 AM 1 Halt-F16 01/05/2023 12:42:00 AM 2 Halt-F16 01/10/2023 2:55:00 AM 3 Halt-F17 01/11/2023 4:01:00 AM 4 Halt-F18 01/17/2023 12:00:00 PM 5 Fault-F35 01/17/2023 10:12:00 PM 6 Fault-F35 01/18/2023 1:58:00 AM 7