There are many approaches to filter one table with another using Power Query. The most common solution I found was to join tables together, and then delete the resulting joined results. This feels like a poor solution, and reviewing Table.Contains, this seems like a good way to provide filtering
Tag: Power Query
Total 2 Posts
One of the really nice features of working with Power Query is the ability to have the tool translate your M language steps into native code in the backend for some data sources. This is called Query Folding, and MSSQLTips has a good introductory article on it, Query Folding in