Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Thank you as always.
The attached image shows the number "8" in a red box, but how can I display the data in that row as 8 duplicates?
Please let me know.
Solved! Go to Solution.
Hi @Tome_05 ,
Thanks for reaching out to us.
This is a common question, and it can be implemented in Power Query Editor.
You can refer to the method in this post.
powerquery - Power Query: Duplicate Rows Based on Value - Stack Overflow
Here's the code:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTJRitWJVnICsozALGcgy1gpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ColA = _t, Stock = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ColA", type text}, {"Stock", Int64.Type}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Col", each List.Repeat({[ColA]},[Stock])), //Adds a column with lists, repeating ColA based on Stock.
#"Expanded Col" = Table.ExpandListColumn(#"Added Custom", "Col") //Expands the lists into individual rows.
in
#"Expanded Col"
Or you can download my attachment for more details.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Tome_05 ,
Thanks for reaching out to us.
This is a common question, and it can be implemented in Power Query Editor.
You can refer to the method in this post.
powerquery - Power Query: Duplicate Rows Based on Value - Stack Overflow
Here's the code:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTJRitWJVnICsozALGcgy1gpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ColA = _t, Stock = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ColA", type text}, {"Stock", Int64.Type}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Col", each List.Repeat({[ColA]},[Stock])), //Adds a column with lists, repeating ColA based on Stock.
#"Expanded Col" = Table.ExpandListColumn(#"Added Custom", "Col") //Expands the lists into individual rows.
in
#"Expanded Col"
Or you can download my attachment for more details.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Tome_05
Please share expected output as well..
You query is not clear like you want 8888 or you want to have duplicate row like 2 rows of 8???
Please look at the attached Excel image.
The idea is that if it displays 8 as in the attached image, then 8 pieces of data will be duplicated.
If the number is 4, I would like it to display 4 duplicate pieces of data.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
57 | |
37 | |
36 |
User | Count |
---|---|
85 | |
65 | |
60 | |
46 | |
45 |