Battery backup calculation required

Hi,

I am at beginner level in PBI and stuck in a problem. Any help is much appreciated.

My problem is that I have nodal (site level) hourly voltage values for multiple days. There are two tables. 1 table is of Max voltages, other table is of minimum voltages. Table structure is the same for both tables. Following are the columns:

Datetime (in hours), Site, Voltage

Now first I need to determine if any site (total are 12k) achieved floating voltage of 53.2 Volts in a day. This is to be determined from max voltage table.

All other calculations are from min voltage table.

Now I need to determine if any site achieved zero voltage (0 Volts) in that day. This is to be determined from min voltage table.

Then further calculations will be done for only those sites that achieved both floating voltage and 0 voltage in the same day for now.

In ideal case, site would achieve floating voltage, then say power outage is observed and voltage starts declining till it reaches zero. In this case, the battery backup would be the time (in hours) from Floating voltage instance/hour to 0 voltage instance/hour. However, the problem is that there can be a situation in which site achieved floating voltage then the voltage started dropping again (due to power outage) and then say the power is resumed before voltage got zero and voltage starts increasing again. in such a case the calculation will not be done.