Get the total time a value spent above a certain threshold

[JesseAtBlue]

Hello,

So i have this dataset which is just data from a sensor, the data type is a number. For each row a DateTime in the corresponding format is provided. However, these are not all joined and contain gaps. See the image below:

I want to calculate the total time any column value (For example NOx) is above a certain threshold. In the end i would want to have a KPI or Map that says: "NOx has been above the threshold value XXXX minutes in the last YYYY period".

I've been trying to get it to work for 2 days, but I just can't seem to figure it out.

[Greg_Deckler · Accepted solution]

See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395.... Also this quick measure:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Mean-Time-Between-Failure-MTBF/m-p/625082