Power Query conditional join between 2 tables

DeadElle

New member
Joined
Jan 5, 2017
Messages
8
Reaction score
0
Points
0
Hello,

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

WuOJtR7.png
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 :)
 
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.
 
Back
Top