Forum Discussion

Ilka719's avatar
Ilka719
Frequent Visitor
3 years ago
Solved

Split by sum in Power bi

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!

 

 

Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    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

     

     

2 Replies

  • mlsx4's avatar
    mlsx4
    Icon for Memorable Member rankMemorable Member
    3 years ago

    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