Power Query conditional join between 2 tables

[DeadElle]

Hello,

I need some help doing a power query that creates a new joined conditional table between these two:

starting from BuyOrdersTable: type MUST be present in SellOrderTable, then price <= 2%.

resulting table should be something like this: http://i.imgur.com/gaFAop0.png

Thanks in advance for any help

 

[El Cid]

Looking at your sample it appears that not only TYPE must match, but also Volume. The change shown in your sample is the price change in the same "lot" that was purchased and then sold. A merge query that selects both columns in each table will get those TYPES and VOLUMES that match. Then add a custom column the calc the difference in price and put a filter on that column that matches your criteria.