Group By, this is the answer.

Choose the grouping keys, then For the first column that will be added, choose Sum for the Balance column as aggregator. For the second column, use whatever aggregation works best for you: Min, Max, Average.

If none is usable, simply do not aggregate, you have the option to return all rows. This action will return a table of results in this column. Next, you can write a simple formula in a new column to return the first item in this table:

=[AllRowsColumn][Price]{0}

In the same manner, you can return the last item in that table of results: [AllRosColumn][Price]{List.Count([AllRowsColumn][Price])}