How can I grab reference their price instead of their sum|Power Query|Excel Forum|My Online Training Hub

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])}