How to merge 2 data tables?

[Minion_grey]

Hi Power BI Masters,

I have this problem and hope that everyone can help me

My database includes: product in and set out (set includes several products)

I want to merge the database from the above tables into 1 table as below, then i can calculate quantity in and out by each product and date

Thank you so much.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

The steps to achieve the goal are for transforming it in Power Query Editor.

[Minion_grey]

Hi,

It works. I really appreciate your solution. You help me a lot. Thank you so much.