Update table only if there is new information in another table.

[AlmarH]

I have two tables in one powerBI. One table that I call All planes has 10 columns, Plane, latitude, longitude, direction, altitude, speed, destination lat, destination lon, arrival lat and arrival long. This table has 10 planes that a company owns and should have the last known position of the planes. The other table is a live feed table that gets every 10 minutes information about planes that are in flight. This table has the same columns. What I want to do is to automatically update the All planes table if there are any of those planes in the live feed table with their newest known position. Otherwise it should keep its last known position. 

Is something like this possible? It probably is really obvious but I just can't seem to find a good way to do it.

[Anonymous · Accepted solution]

Hi @AlmarH ,

In Power Query, you can try merging two tables to get the new values.

Merge queries overview - Power Query | Microsoft Learn

If you also consider in Power BI Desktop, you can simply use RELATED(TableB[Country Codes)) to get CountryCodes in TableA

or use LOOKUPVALUE if they are not related.

Reference: Good Ol' VLOOKUP - The Ultimate Guide to Lookups i... - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.