Forum Discussion
DAX command to duplicate rows
Hi jwb3d ,
Can you please elaborate a little bit more on the requirements and supply some example?
But based on the overall understanding believe this is better done using Power Query and not DAX, but if you can share the example is easier to give you the correct approach.
I need rows which have count column > 1 to be duplicated by the number of times the count represents.
See the image below.
Hi jwb3d
For this you should use the Power querry because you cannot duplicata tows on a table already loaded só to use dad you would need to create a new table.
On Power query add a column with the followinf code
{1..[Count]}
This Will generate a list of values starting at 1 and ending in the number of the count inside the cell that you can then expand creating a repeted row for each value.
Then you can delete that new column