Managing repeat groups with Power BI

This is quite off-topic from this thread, it would be better if you started a new thread.

One possible solution would be using the Power Query Editor (Home ribbon, Transform data button).

Select all the other columns (besides lat and lon), then choose Group By. In the Group By pop-up choose Advanced. Choose Add aggregation, then choose New column name = lat, Operation = Max and Column = lat. Repeat for lon. You can delete or ignore the default Count aggregation.

It should then summarise the pairs of rows you are seeing into one, with populated lat and lon values.

If I’ve misunderstood your requirements, please start a new thread and post more info.

2 Likes