PDA

View Full Version : Power Query conditional join between 2 tables



DeadElle
2017-01-05, 08:03 PM
Hello,

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

http://i.imgur.com/WuOJtR7.png http://i.imgur.com/Kmvurow.png

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
2017-01-10, 02:49 PM
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.