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.
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.
Below are two weblinks showcasing the same filter script I am having an issue with. My script is as follows.
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.
myName = Table.SelectRows(fxCalc_MeterDateBusinessKey, each List.Contains(stage_SummaryTicket[MeterDateBusinessKey], [MeterDateBusinessKey]) = false)
Reference
Quick Tips: How to Filter a Column by another Column from a Different Query in Power Query
#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
Image