Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Manohar_MS
Frequent Visitor

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.

Manohar_MS_0-1692598067364.png

Table B: Previous Months Sales and it have all countries net sales information.

Manohar_MS_1-1692598149413.png

 

I need to bring only table A countries related data from Table B.

Manohar_MS_2-1692598233259.png

 

 

The final view of Table A need to acheive like above.

 

Thanks.

Manohar

1 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

vxinruzhumsft_0-1692760247415.png

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.

 

View solution in original post

8 REPLIES 8
Manohar_MS
Frequent Visitor

No, Append will bring all countries from Table B but I need information from Table B only for Table A countries.

@Manohar_MS , I think merge with inner join option should do

Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak ,

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

Manohar_MS_0-1692600002807.png

 

@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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak 

expected table like below:

Manohar_MS_1-1692600085353.png

 

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

vxinruzhumsft_0-1692760247415.png

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.