Events for a Period time

[aescoba]

Hello I'm begings to use Power BI and I'm interesting to know if someone can help.

Problem:

How to measure the correct Duration by Hour?

If I sum the column"Hour" I get a wrong value of 143 instead of 104.18 as table below.

My doubt is I need to duplicate the rows breakdown the times or it's possible a metric to analize the data.

Start	End	Duration (sec)	hour
2022-09-09T07:58:15.753	2022-09-09T07:58:21.820	6	7
2022-09-09T07:58:21.820	2022-09-09T08:00:38.357	137	7
2022-09-09T08:00:38.357	2022-09-09T08:04:48.450	250	8

Hour	SUM_Duration by hour	Sum_Duration by period
7	143	104.18
8	250	288.82

[lbendlin]

Your request is much more complex than it may sound.  For each event you need to find the intersect of your event interval with the Hour buckets. Events can also span multiple hours and even days.

- Please confirm that second level accuracy is enough. Specify the rounding rules

- Specify the expected bucket sizes (hours/days etc)

- Confirm that you want all this to be done in UTC

- provide sample data that covers all scenarios