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 Team,
Good Day !
I'm trying to mimic this SQL script in dax powerbi
SELECT * FROM TABLE1 WHERE TABLE1[ID] IN (SELECT TABLE2[ID] FROM TABLE2)
I'm trying to use filter and the IN operator however there is no prepared statement that I can use in Dax. Can you please help me achieve the same scenario. I prefer to do dax statement instead of doing it on the 'powerquery'
Thanks for your help in advance
Cheers!
Solved! Go to Solution.
Thank you!!