Forum Discussion
MTBF calculation different structure of data
Hello everyone, I am new in PowerBI and I think this question is tricky but hope it is not for experienced users. I am trying to calculate MTBF(Mean Time Between Failures) but my data structur...
Hi Anonymous ,
I've had a play around with your PBIX file and think I've managed it. Take a look here:
First I added a custom column to get the Breakdown Duration in minutes:
BreakdownDuration-Minutes = data[BreakdownDuration] / 60
Ideally you should do that in Power Query but I didn't have access to do it here.
To get the Total Uptime I used:
Total Uptime = IF( SUM( data[ShiftDuration]) = 0 , 0 , CALCULATE( AVERAGE( data[ShiftDuration] ) - SUM( data[BreakdownDuration-Minutes] ) ))To get the MTBF I used:MTBF = IF( SUM(data[ShiftDuration]) = 0 , 0 , DIVIDE([Total Uptime], SUM( data[EventCount] ) , 0 ))Hope this helps.
Hi Anonymous ,
I've had a play around with your PBIX file and think I've managed it. Take a look here:
First I added a custom column to get the Breakdown Duration in minutes:
BreakdownDuration-Minutes = data[BreakdownDuration] / 60
Ideally you should do that in Power Query but I didn't have access to do it here.
To get the Total Uptime I used:
Total Uptime = IF( SUM( data[ShiftDuration]) = 0 , 0 , CALCULATE( AVERAGE( data[ShiftDuration] ) - SUM( data[BreakdownDuration-Minutes] ) ))
To get the MTBF I used:
MTBF = IF( SUM(data[ShiftDuration]) = 0 , 0 , DIVIDE([Total Uptime], SUM( data[EventCount] ) , 0 ))
Hope this helps.