Forum Discussion
Create a new table with last known record
Hi Rolf
Sorry for getting back late. In Power Query, you can achieve exactly the same reults
1) Create a duplicate table/query
2) Use the "Group by" ....... Group by Equipment.......New Column with Maximum Date
3) Then Go to Merge Queries (merge the above table with orginal table)
4) Select Date and Equipment Columns in both tables (Two Column match)
5) Expand Table Selecting LAT and LON
Community ChampionHi Rolf
Sorry for getting back late. In Power Query, you can achieve exactly the same reults
1) Create a duplicate table/query
2) Use the "Group by" ....... Group by Equipment.......New Column with Maximum Date
3) Then Go to Merge Queries (merge the above table with orginal table)
4) Select Date and Equipment Columns in both tables (Two Column match)
5) Expand Table Selecting LAT and LON
Was worth the wait ;) This is exactly what i needed. Thank you very much. I had the same issue with duplicates but just added a remove duplicate step which gives me an excellent unique list of last known location.