Filter table by table

[Anonymous]

Hello

Is it possible to filter one table using another?

Ie. filter:

Col1	Col2	Col3
1	2	3
1	2	3
1	2	3
1	2	3

Using:

Col2	Col3
2	3
1	2

I would like to filter Table1 by Col2 (values from Table2[Col2]) and by Col3 (values from Table2[Col3]).

I am looking for a single function that can do this is possible so that it is fully dynamic instead of creating a multistep code?

Thanks!

[Anonymous]

@v-jingzhang thanks, the logic is that the source table is filtered by the filter table in a way that the values of each column in Table2 will be used to filter the same column in Table1. Any quick function for that?

[v-jingzhang]

Hi @Anonymous 

It may be possible but the requirement is not clear currently. What should be the result when you use Col2 and Col3 from Table2 to filter Table1? And how will you filter Col2 and Col3? Can you provide some examples to help explain the expected output when filtering?

Best Regards,
Community Support Team _ Jing