Forum Discussion
Anonymous
7 years agoNot applicable
Split rows based on condition
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?
No Replies