Power BI, rule management (inner join)

Question

I have to do in DAX this code, for simplicity I write it in SQL, practically I have to translate this SQL in DAX:

select 'id'
from x , y 
where x.client == y.client 

I can't figure it out because I can't understand how to make this kind of join in using the DAX syntax.

Answer 1

Using Power Query in Power BI you can make an inner join:

tbl1:

tbl2:

Script:

let
    Source = Table.Join(tbl1, {"client"}, tbl2, {"client"}, JoinKind.Inner)
in
    Source

Result: