Battery backup calculation required

[rzafar]

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.

[Greg_Deckler]

@rzafar Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.