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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
CTozzi
Resolver I
Resolver I

How to generate 12 rows for each existing row with Power Query

Hi everyone,

 

I have a table with monthly target sales by product and Seller as below:

A1.PNG

And I would like to add a NEW column and 12 lines for each existing lines as below:

A11.PNG

 

Thank you very much!

1 ACCEPTED SOLUTION
mahoneypat
Employee
Employee

Just add a custom column in the query editor with this formula   = {1..12}

That will add a list on each row.  You then just need to click on the expand button on the top of that column and choose "Expand to New Rows".

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

1 REPLY 1
mahoneypat
Employee
Employee

Just add a custom column in the query editor with this formula   = {1..12}

That will add a list on each row.  You then just need to click on the expand button on the top of that column and choose "Expand to New Rows".

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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