SQL IN parameter from the existing column in Power BI table

[Anonymous]

Hi All,

 I am excuting the SQL IN query from SAP Database and rather than manually enter the IN data (e.g. mobile numbers) and then refresh the table, I want the SQL IN to automatically pick up the data from a column(mobile number) present in existing table(table 2) in same Power BI desktop.

Eg. 

Select * from table 1

where field3 IN ( mobile number from table 2)

table 2

Mobile number

111111111

222222222

333333333

444444444

555555555

[Anonymous]

My Table 1 is an SQL IN function from external database and it should pick up the IN data from the existing data in POwer BI desktop which is from different source.

[ThxAlot]

Calculated Table = 
FILTER(
    Table1,
    NOT ISEMPTY(
        FILTER( Table2, Table2[Mobile number] = Table1[Field3] )
    )
)

In terms of SQL in your scenario, EXISTS() is more efficient than IN

SELECT *
FROM Table1
WHERE EXISTS(
    SELECT NULL FROM Table2 WHERE Table2.[Mobile number] = Table1.Field3
)

[Anonymous]

What is the this used for Calculated Table = FILTER( Table1, NOT ISEMPTY( FILTER( Table2, Table2[Mobile number] = Table1[Field3] ) ) ) Can we use Dynamic M Parameter. If yes, can you please show step by steps