Forum Discussion
Solved
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...
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.
Idrissshatila
Super User
Super UserHello 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