Forum Discussion
Solved
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 n...
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)] }
spinfuzer
Solution Sage
Solution SageYou could add a custom column which creates list from 1 to span and then expand column to new rows.
={1 .. [Span (Months)] }