Problem with Uptime Calculation

[jmac88]

I am trying to calculate the uptime percentage with dynamic date ranges for all of my assets (Reactive Category), I have start time and end time of repairs, but I am having trouble defining availability time for my assets depending on the date range I select, the site is open 24/7.

I created a calendar table that is calculated with the dates on my raw data, and made the relation between both of them.

I need to be able to select date ranges and based on the days selected, that it would calculate how many hours it is supposed to be available, and if there is downtime on that range, it calculates the uptime percentage.

The following image shows an example of the data I am working with:

Any thoughts on how to get this issue resolved will be greatly appreciated.

[v-zhenbw-msft]

Hi @jmac88 ,

Sorry for that we are not clearly about your desire result.

Do you want to the difference between start and end? You can create a difference column using DATEDIFF function.

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.