Forum Discussion
AV_04
3 years agoHelper I
Power BI Help
Hi Team, I have these two tables: Product Code Date Position ID Common Column A 1 6/3/2023 1 12 A-1-6/3/2023-1-12 C 3 6/4/2023 2 13 C-3-6/4/2023-3-32 S 2 6/5/2023 r...
- 3 years ago
Hi AV_04
If the columns are same in both tables, you can merge the tables based on the "Product" which seems to be unique in each table.
You can go to "Transform Data" -> Under Home select "Merge Queries" and select as below:This produced me the desired output as below:
Hope this works for you!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AV_04
3 years agoHelper I
Hi amitchandak could you please help me on this?