Forum Discussion
Help Needed on Joining two tables into one table
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.
Super UserManohar_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.
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.
- amitchandak
Manohar_MS , Create the above as separate table with columns of B(Innerjoined with A) remove extra columns and then append again with A
That can help with help from menu , else we need play with list and table functions