Create Duplicate Defect Entries based on Column Value

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-a-new-column/m-p/818837/highlight/true#M393542

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.