Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter table by table

Hello

 

Is it possible to filter one table using another?

 

Ie. filter:

Col1Col2Col3
123
123
123
123

 

Using:

Col2Col3
23
12

 

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!

Need Help
Show and Tell
Tutorial Requests

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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?