Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not 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 .

 

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?

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.