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 ChampionRows 3 and 4 of the original table you posted have same date and same equipment i.e equipment a and date 2-1-2017 0:00
Thats why they would be duplicated
Makes sense. Thanks a lot. Do you know of any way to do this in the Power Query environment as well?
- Zubair_Muhammad
I think so it can be done using Merge Queries in Power Query.
Have got to leave. Will get back to you on this- Zubair_Muhammad
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 LONWas 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.