Help Needed on Joining two tables into one table

[Manohar_MS]

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

[Manohar_MS]

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

[Manohar_MS]

@amitchandak ,

I am getting two separate column like below but I want NS & Date columns need to append with table A columns.

[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

[Manohar_MS]

@amitchandak 

expected table like below:

[v-xinruzhu-msft · Accepted solution]

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]

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💡

[Manohar_MS]

I need matching countries information only from Table B & columns need to append according to Tbl A