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.
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.