Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Microsoft
power bi
Power Query
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous 

     

    Create a Custom Column as shown below.

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

     

    Hope this helps.

     

    Please mark as a solution if serves right.

    Thanks

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

 

Create a Custom Column as shown below.

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

 

Hope this helps.

 

Please mark as a solution if serves right.

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous  thank you 🙂