Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
How could I make so many duplicate rows if I have an amount in one row and that amount goes to 1?
Thanks in advance!
Solved! Go to Solution.
Hi @Ilka719
In Power Query, add a custom column with this code:
Table.Repeat(Table.FromRecords({[Col1=1]}),[Amount])
And now, expand values:
Finally, remove the original amount column, and rename the custom as Amount
Hi @Ilka719
In Power Query, add a custom column with this code:
Table.Repeat(Table.FromRecords({[Col1=1]}),[Amount])
And now, expand values:
Finally, remove the original amount column, and rename the custom as Amount
Great! Thank you!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |