Forum Discussion
How to merge 2 data tables?
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.
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.
2 Replies
- Jihwan_Kim
Super User
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.
Hi,
It works. I really appreciate your solution. You help me a lot. Thank you so much.
