Split by sum in Power bi

[Ilka719]

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!

[mlsx4 · Accepted 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

[Ilka719]

Great! Thank you!