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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Create the specified number of lines from one line.

Hello everyone.
I have a table. In one column - the number of the event, in the second - the quantity. I really need to decompose such lines into several. If there are 4 events, then 4 lines are needed, if 2 - then two. How can this be done optimally?

 

2021-09-24 11_51_16-Book2 - Excel.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

In PQ add new column: 

   Table.AddColumn(prev_step, new_column_name, each List.Numbers(1,[COUNT])),

 where [COUNT] is column with events count.

Then expand lists in new column.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

In PQ add new column: 

   Table.AddColumn(prev_step, new_column_name, each List.Numbers(1,[COUNT])),

 where [COUNT] is column with events count.

Then expand lists in new column.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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