Forum Discussion
How can I add additional duplicate rows in Power BI based on a specific number in a column?
Hi,
I would like to explore options for adding additional duplicate rows in Power BI based on a specific number in a column. For instance, as illustrated below, I aim to replicate my rows the same number of times as indicated in the 'Span(Months)' column. Can someone suggest an automated method for achieving this?
hello, abhilashmjoseph
to_list = Table.TransformColumns(your_table, {"Span (Months)", (x) => List.Repeat({1}, x)}), expand = Table.ExpandListColumn(to_list, "Span (Months)")You could add a custom column which creates list from 1 to span and then expand column to new rows.
={1 .. [Span (Months)] }
4 Replies
- AlienSx
Super User
hello, abhilashmjoseph
to_list = Table.TransformColumns(your_table, {"Span (Months)", (x) => List.Repeat({1}, x)}), expand = Table.ExpandListColumn(to_list, "Span (Months)")Thnak you for the response , but not quite clear can you please elaborate ?
I am unable to successfully format the proposed solution. I continually receive the error message: "A cyclic reference was encountered during evaluation." Could you kindly provide the complete function? Thank you.
spinfuzerSolution Sage
You could add a custom column which creates list from 1 to span and then expand column to new rows.
={1 .. [Span (Months)] }
