Hello,
I am really hoping someone is able to help with this issue I am facing.
I have two tables in Excel, an extract of these table is described below.
Table 1 - Columns
assetId,
startLocationId,
endLocationId
Table 2 - Columns
assetId,
homeLocationId
what I want to do is the equivalent for this....
I have a NestedJoin in the Power Query Editor which does most of the work except for the last <> comparison, I do not know how to do this and I am struggling to find anything on the web about it.
There is something I have found called
from the Microsoft Docs website "docs.microsoft.com/en-us/powerquery-m/table-nestedjoin"
But no examples or what options there are.
Any help is greatly appreciated.
Bookmarks