The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
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
)
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LearnAndPractise(Everyday) ) |
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
User | Count |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
50 | |
46 |