How to I combine two measured tables? DAX preferred.

[dmilardo_au]

I have two measured tables. Both have the same number of columns and have the same name. 

One of the columns of both tables has id's and an other one has a label number for each row. The other columns are needed information for an other process.

The combined table should exchange all rows of table 1 with all rows of table 2 based of the id's. 

[Shubham_Tekade]

Hello @dmilardo_au ,

refer to - https://www.youtube.com/watch?v=KS1pEC2kSyo

Thanks,

Shubham

[Idrissshatila]

Hello @dmilardo_au ,

You could use the union function.

Check it here https://dax.guide/union/

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[dmilardo_au]

Thanks for your response @Idrissshatila.

I tried that but I don't want a simple fusion of these tables.

All rows of table 1 with the same id in the id column of table 2 should be exchanged with these rows of table 2.