title: PowerQuery - Filter rows that do not exist in another Table.[Field] list of values
body: <p>I have a PowerQuery M script that is supposed to filter the table and keep rows that do not exist in another Table.[Field] list.</p>
  <p>The source table has 2489 rows. The lookup list has 1828 rows. But my script runs forever and the feedback bar shows a row count in the millions, and it doesn't stop running.</p>
  <p>Below are two weblinks showcasing the same filter script I am having an issue with. My script is as follows.</p>
  <p>Am I doing something wrong? Why is the query running forever and displaying millions of rows in the feedback bar? It's gotten as high as 24M before I cancelled the query.</p>
  <blockquote>
  <p>myName = Table.SelectRows(fxCalc_MeterDateBusinessKey, each List.Contains(stage_SummaryTicket[MeterDateBusinessKey], [MeterDateBusinessKey]) = false)</p>
  </blockquote>
  <p><strong>Reference</strong></p>
  <p>Quick Tips: How to Filter a Column by another Column from a Different Query in Power Query</p>
  <p><a href="https://www.biinsight.com/quick-tips-how-to-filter-a-column-by-a-column-from-a-different-query-in-power-query/" rel="nofollow noreferrer">https://www.biinsight.com/quick-tips-how-to-filter-a-column-by-a-column-from-a-different-query-in-power-query/</a></p>
  <p>#PowerQuery – Filter a table based on another table column or list – and some Filter aha’s – Erik Svensen – Blog about Power BI, Power Apps, Power Query</p>
  <p><a href="https://eriksvensen.wordpress.com/2017/12/12/powerquery-filter-a-table-based-on-another-table-column-or-list-and-some-filter-ahas/" rel="nofollow noreferrer">https://eriksvensen.wordpress.com/2017/12/12/powerquery-filter-a-table-based-on-another-table-column-or-list-and-some-filter-ahas/</a></p>
  <p><strong>Image</strong></p>
  <p><a href="https://i.stack.imgur.com/2rSXN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2rSXN.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/UqLmr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UqLmr.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/a0OfZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/a0OfZ.png" alt="enter image description here" /></a></p>