Split data into hourly buckets based off Start/End datetime?

Question

I am starting with a simple table that contains Start and End values:

Based off these values, I would like to generate a new table that is bucketed into hourly values. My desired result would look like this:

Any help on generating a result like this is much appreciated! Thanks you.

anonymous · Accepted Answer

Hi&nbsp;chad_oge&nbsp;
You can get the time list first and then subtract in chronological order .
Refer the following link to return the hourly values
https://community.powerbi.com/t5/Community-Blog/Convert-the-start-time-and-end-time-into-multiple-rows-with-30/ba-p/1478630 
&nbsp;
Best Regards
Community Support Team _ Ailsa Tao
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Split data into hourly buckets based off Start/End datetime?

1 Reply

Related content

Error in Power Query combining overlapping start end datetime fields

EBIT Financial Bridge - Dynamic Start and End

Create DateTime List between start datetime & end DateTime

Between date filter with fixed start date and latest end date

Start and end selection with datetime