Merge Query

[matty1184]

Hello everyone! I state that I am a beginner with Power Query! I have two tables containing two columns each: table 1: -Telefono1 -Mail1 Table 2 -Telefono2 -Mail2 I would like to filter the rows of table 1 that contain at least one value corresponding to table2. I had thought of linking phone & mail together with the tables and using the MERGE function by entering the approximation but I can't get any results, while if I only use the phone I get a filter. do you have suggestions? Thanks in advance!

[Sergiy]

Hi @matty1184 ,

I am not sure I got you right.

Here is a sample for you:

https://www.dropbox.com/s/dvmlyku6z6auggz/MergeQuery.pbix?dl=0

Is it what you were after?