- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

hello, @abhilashmjoseph
to_list = Table.TransformColumns(your_table, {"Span (Months)", (x) => List.Repeat({1}, x)}),
expand = Table.ExpandListColumn(to_list, "Span (Months)")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You could add a custom column which creates list from 1 to span and then expand column to new rows.
={1 .. [Span (Months)] }
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You could add a custom column which creates list from 1 to span and then expand column to new rows.
={1 .. [Span (Months)] }
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

hello, @abhilashmjoseph
to_list = Table.TransformColumns(your_table, {"Span (Months)", (x) => List.Repeat({1}, x)}),
expand = Table.ExpandListColumn(to_list, "Span (Months)")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
7 | |
7 | |
6 |