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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Explode and duplicate Rows

Dear all,

 

I have a little problem on Power Query,

In fact, I integrated TABLE1 from an Excel file and in Power BI and I want to transform the table and explode it according to the number of days off (by modifying the date each time of END) as shown below.

case pff.JPG

 

 

there is any solution to do it in Power Query PBI?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous 

 

Create a Custom Column as shown below.explode.PNG

After creating above column expand the rows and apply necessary transformations.

 

Hope this helps.

 

Please mark as a solution if serves right.

Thanks

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @Anonymous 

 

Create a Custom Column as shown below.explode.PNG

After creating above column expand the rows and apply necessary transformations.

 

Hope this helps.

 

Please mark as a solution if serves right.

Thanks

Anonymous
Not applicable

@Anonymous  thank you 🙂

amitchandak
Super User
Super User

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors