Forum Discussion
Calculate Duration Datetime and Sum
That will sum all duration and not only the duration that belong to the purple area on the image, so that will never work for this case.
I need something like this example https://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586, but i dont have the started repair and end repair date witch i dont know to apply this to my case.
Hi,
In a spare column, share the exact result you are expecting.
Ashish_MathurThis is something very siilar that i planned to get ,but i want to get sum the duration of the datetime inside the purple area in my image. like he got between failures.
That is not what i am expecting from you. I want the exact numeric answer you are expecting. Once i write my DAX formula, i will then compare my answer with yours.
This is a example of an expected output:
AverageTimeFailure 2Days10Hours20min By Sum the duration of each date duration inside purple area it will give that.
Basically the column will be that AverageTimeFailure (Sum(All durations inside purple area and next divide by the number of fails), hope i helped you with this.