Power Query - Combine List.Contains with Greater Than or Equal To

[berian]

I have two tables which look like below:

Lookup

Qty	Stock Code
500	LANDECCOM130
200	SANWETSCR157
2000	CAJGGRCOR01

Data

Stock Code	Qty	Customer Name	Mobile No.
LANDECCOM130	652​	Customer 1	+447123456781
SANWETSCR157	121​	Customer 2	+447123456782
SANWETSCR157	212​	Customer 3	+447123456783
LANDECCOM130	258​	Customer 4	+447123456784
CAJGGRCOR01	1288​	Customer 5	+447123456785
SANWETSCR157	91​	Customer 6	+447123456786
CAJGGRCOR01	4050​	Customer 7	+447123456787

Using power query I would like to use every row from the lookup table to pull the only those rows in the data table.

For example Show all rows that are have the Stock Code 'LANDECCOM130' and a 'Qty' greater than or equal to 500 - AND - Show all rows that are have the Stock Code 'SANWETSCR157' and a 'Qty' greater than or equal to 200, etc.

I've tried using a list.contains on the stock code and that pulls the stock codes for me, but I can't seem to be able to combine this with the greater than or equal to for the quantity.

Any advice would be gratefully received.

 

[RoryA]

You could do a simple merge of the two tables using the stock code to add a column to the data table showing the relevant Qty threshold. Then simply add a calculated column that checks if the actual qty is greater than the threshold and filter the resulting query for rows where the calculation is true.

 

[berian]

You could do a simple merge of the two tables using the stock code to add a column to the data table showing the relevant Qty threshold. Then simply add a calculated column that checks if the actual qty is greater than the threshold and filter the resulting query for rows where the calculation is true.

Perfect! Think I was over thinking things here!

Thanks for the assist!