Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 .

 

RoomIDStart DateEnd Date Duration 
109:0011:00120 
209:0010:0060 
311:0012:3090 

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