Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Dorota
Regular Visitor

Analazing events with duration

Hi All,

 

Thanks in advance for any supporting comments/sugestions.

 

What I am strugling with now is some analyzis of events with start and end date. I actually need to see trend of events over time and worked out the way to calculate the daily averages from events. But it is not fully correct. Here is an example for exact explanation:

 

I have deferment production events in tabel1 as follow:

 

Unique ID EventUnique Well IDLevel1Level2StartEndVolume total
Event1Well1PlannedWell28/12/201629/01/20172
Event1Well2PlannedWell01/01/201710/01/201710
Event2Well3UnplannedWell02/01/201707/01/20175
Event3Well4PlannedFacility11/01/201717/01/201710
Event3Well3PlannedFacility29/01/201703/02/201750
Event 4Well 5UnplannedFacility13/12/201612/01/201712
Event 5Well 1PlannedWell06/02/201707/02/20173

 

I have another calender tabel2 and calculate the volume per each day in calender with dax as follow:

 

Daily:=Calculate(Sum(Table1[Volume/day]),Filter(Table1,(Table1[Start]<=LASTDATE(Table2[Date])&&Table1[End]>=FIRSTDATE(Table2[Date]))))

 

But that is based on average volume per day. I calculate duration in days and assigned to each day average volume. What i really seek a solution for now is calculate exact amount of hours of duration of event on each day and assigned propoer volume like follow:

 

Event1Well1PlannedWell28/12/2016 09:0029/01/2017 13:002
Event1Well2PlannedWell01/01/2017 23:0010/01/2017 02:0010

 

So for example Event1 on Well 2 last only for 1 hpurs on 01/01/2017 so I shall find a way to calculate volume per hour and then assign to each day in calender table correct amount of downtime hours on each day and then proportional volume

 

Thanks for suggestions 🙂

 

Regards

 

Dorota

0 REPLIES 0

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors