Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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!

2 Replies

  • vapid128's avatar
    vapid128
    Icon for Solution Specialist rankSolution Specialist
    FILTER(TABLE1 , TABLE1[ID] in VALUES(TABLE2[ID]))
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you!!