Forum Discussion
SQL IN parameter from the existing column in Power BI table
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 ...
ThxAlot
Super User
Super UserCalculated 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
)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