Forum Discussion
Anonymous
4 years agoNot applicable
How to filter a Table USING IN Operator with the Values from another Table ?
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!
- FILTER(TABLE1 , TABLE1[ID] in VALUES(TABLE2[ID]))
2 Replies
- vapid128
Solution Specialist
FILTER(TABLE1 , TABLE1[ID] in VALUES(TABLE2[ID]))- AnonymousNot applicable
Thank you!!