Split rows based on condition

[Anonymous]

Hi,

I am working on this scenrio but not getting around anywhere.

In my Room booking scenario I have to split my rows hourly .

RoomID	Start Date	End Date	Duration
1	09:00	11:00	120
2	09:00	10:00	60
3	11:00	12:30	90

RoomID 1: should repeat 2 times (09:00-10:00 ,10:00-11:00)

Room ID 2: no repeat

Roomid 3: repeat 2 times 

How can I achieve this in power bi?