How can I add additional duplicate rows in Power BI based on a specific number in a column?

[abhilashmjoseph]

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?

 

[AlienSx · Accepted solution]

hello, @abhilashmjoseph 

    to_list = Table.TransformColumns(your_table, {"Span (Months)", (x) => List.Repeat({1}, x)}),
    expand = Table.ExpandListColumn(to_list, "Span (Months)")

[spinfuzer · Accepted solution]

You could add a custom column which creates list from 1 to span and then expand column to new rows.

={1 .. [Span (Months)] }

[AlienSx · Accepted solution]

hello, @abhilashmjoseph 

    to_list = Table.TransformColumns(your_table, {"Span (Months)", (x) => List.Repeat({1}, x)}),
    expand = Table.ExpandListColumn(to_list, "Span (Months)")

[abhilashmjoseph]

Thnak you for the response , but not quite clear can you please elaborate ?