Forum Discussion
Solved
check if value contains in another table
I have "clien's" table with client_id, and i have another table "invoices" where each invoice has client_id. with power query I need to add in "client's" table column yes/no to check if every cl...
Add a custom column with:
= List.Contains(InvoiceTable[client_id], [client_id])Where InvoiceTable is the query name of your invoice table.
Add a custom column with:
= List.Contains(InvoiceTable[client_id], [client_id])Where InvoiceTable is the query name of your invoice table.
I implemented this between two tables with fewer than 30K rows each and got a pretty substantial performance hit when going to apply changes, FWIW.
Agreed, I tried this with ~150k rows, and it's unusable. Very good for small datasets though
HowardLJ - did you find a workaround for large datasets?
