Create Duplicate Defect Entries based on Column Value

[carlin93]

Greetings,

I am attempting to utilize a Calculated New Table to create duplicate entries based on the count column. The 'table' I am referencing is called 'Defect Count'.

I also would like for an additional column that tracks the iteration of the defect. I have provided an example below.

Example:

Original Data Table 'Defect Count'

Defect	Count
Too Short	3
Bump	1
Brittle Blade	2

Disered Result

Defect	Count	Iteration
Too Short	3	1
Too Short	3	2
Too Short	3	3
Rust	1	1
Brittle	1	1
Bump	2	1
Bump	2	2
Rust	4	2
Rust	4	3
Rust	4	4
Rust	4	5

[vicky_ · Accepted solution]

You can copy the solution here in PowerQuery, which I recommend over trying to do the same thing in DAX - https://community.fabric.microsoft.com/t5/Desktop/Table-TransformColumns-repeat-rows-n-times-and-add...

[Anonymous · Accepted solution]

Hi @carlin93 

Based on your needs, I have created the following table.

Create a new custom column by using the following code in power query:

= List.Numbers(1, [value])

Then click "Expand to New Rows".

Click "Close and Apply".

This is the result you want.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[carlin93]

Thank you, this also helped me as well 

[vicky_ · Accepted solution]

You can copy the solution here in PowerQuery, which I recommend over trying to do the same thing in DAX - https://community.fabric.microsoft.com/t5/Desktop/Table-TransformColumns-repeat-rows-n-times-and-add...

[carlin93]

Thank you! This helped a lot