Search code examples
joinpowerbidaxinner-joinpowerbi-desktop

Power BI, rule management (inner join)

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.

Solution

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

    tbl1:
    enter image description here

    tbl2:
    enter image description here

    Script:

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

    Result:
    enter image description here