Ilka719Frequent Visitor3 years agoSolvedSplit 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! Show Moremlsx43 years agoHi 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
mlsx43 years agoHi 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
mlsx43 years agoHi 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
mlsx4Memorable Member3 years agoHi 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
Related contentSplitting Column valuesRunning sumFiltering a Sumsplit or extract?Improper Sum with slicer
