April 25, 2019
I have a query that presents all invoices in the current year to date. I would like to filter this data by customer, using a separate list of our top 20 customers by spend.
I have tried using the following, where tTopCustomers is my separate tabulated list of top 20 customers and [CUSTOMER] is the column in the invoice data that I wish to filter:
= Table.SelectRows(#"Reordered Columns", each Table.Contains(tTopCustomers, [CUSTOMER]))
But this only results in an expression error along the lines of
"We cannot convert the value "*CUSTOMERNAME*" to type Record.
First of all, am I using a valid function to achieve the desired filter and if so, how do I correct the error?
Also, I had originally tried to use List.Contains, however I'm unable to find a way to convert the table query to a list - is this possible in excel?
Thanks for your help 🙂
July 16, 2010