Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

POWERBI: Join tables through the same column

I have two tables with the same columns and I want to make a union between them, so that I get a table in which I have only the products_id that match each other. Simplifying my case and omitting th...
  • Barthel's avatar
    Barthel
    4 years ago

    Hey,

     

    Based on your example, this function should provide the desired result:

    TOTAL TABLE =
UNION ( TABLE1, INTERSECT ( TABLE2, TABLE1 ) )

     

    Result:

     

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Syndicate_Admin ,

 

Table merging can be achieved both through the append function in power query and by creating dax formulas in powerbi.
Refer to the solution given by Barthel SpartaBI  for details.

 

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry