Mean Time to Repair and Mean Time Between Failures

[spandana]

Hello Everyone,

I have a come across this issue of calculating the MTTR and MTBF.

There are DAX measures with a start and end date - But in the date I have the resolved time in decimal ( Fraction of hours ).

I have 3 columns - 

 

Where column A is the ID, Column B is the alert and which my asset for MTTR AND MTBF based on which the calculation should be made and the column C is the time in decimal form of hours.

Any help would be greatly appriciated.

Thank you

[amitchandak]

@spandana ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

Check if this new column can help

new column =
var _ max = maxx(filter(Table, [B] = earlier([B]) && [C] < earlier([C])),[C])
return
[c] - _max