Events for a Period time
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