October 7, 2022
I have a table with P&L data and i need to filter out certain account names. See Raw Data tab. I have a table of all the account names that should be filtered out (tab Filter List). I loaded the filter list to a query and converted it to a list. I ensured that the type of the list records is Text. Then i created a Query called PL that pulls the table from the Raw Data tab and that is supposed to filter out any records matching the Filter list (GLTotals query). I am not getting an error message, but the list is not being filtered at all (see tab PL). I am not sure why this does not work. The Data Types match, i used the Trim function in Excel to ensure that there are no extra spaces and it still does not work. ChatGPT could not figure it out either 🙂 Any help is appreciated. File is attached.
January 31, 2022
Use this line of code to filter the RowData based on a list.
Table.SelectRows(#"Changed Type", each List.Contains (GLTotals, [RowData]))
Read more about it in the article in the link below:
Perhaps you're better off by using Merge as that seems to work faster. It's mentioned towards the end of the article.