Forum Discussion
Help Needed on Joining two tables into one table
Hi All,
I have 2 tables.
Table A: Current Month data with selected countries net sales.
Table B: Previous Months Sales and it have all countries net sales information.
I need to bring only table A countries related data from Table B.
The final view of Table A need to acheive like above.
Thanks.
Manohar
Hi Manohar_MS
You can create a new calculated table
Table = VAR a = SUMMARIZE ( FILTER ( 'Table B', [Country] IN VALUES ( 'Table A'[Country] ) ), [ID], [Country], [NS], [Date] ) RETURN UNION ( 'Table A', a )Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
- Idrissshatila
Super User
Hello Manohar_MS ,
so you go to transformation data (aka Power Query) then you click on append queries and pick these two tables.
check this for more instructions https://learn.microsoft.com/en-us/power-query/append-queries
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡I need matching countries information only from Table B & columns need to append according to Tbl A
No, Append will bring all countries from Table B but I need information from Table B only for Table A countries.
- amitchandak
Manohar_MS , I think merge with inner join option should do
Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo
I am getting two separate column like below but I want NS & Date columns need to append with table A columns.
