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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nchand
Regular Visitor

How to add values from a column of Table A to new column of Table B? Many to many relationship.

Hi,

 

I have the table A with the following cols : PowerBI.jpg

And Table B with following col: 

PowerBI.jpg

I need to add a new col to table B Home SubRegion. How to match these LGA values to correct homesubregion? please help. Thanks

 

1 ACCEPTED SOLUTION
sturlaws
Resident Rockstar
Resident Rockstar

Hi,

if you want to achieve this using dax:

New colunm = lookupvalue(TableA[HomeSubRegion],TableA[HomeLGA],TableB[OrigLGA])

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

View solution in original post

4 REPLIES 4
AlB
Super User
Super User

@nchand 

Probably best to do this in Power Query directly, with a simple merge. Paste the two tables above in text-tabular format instead of ona  screen cap (so that table contents can be copied) and we'll work it out

SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

sturlaws
Resident Rockstar
Resident Rockstar

Hi,

if you want to achieve this using dax:

New colunm = lookupvalue(TableA[HomeSubRegion],TableA[HomeLGA],TableB[OrigLGA])

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

After doing this I get many blanks in the newly created column. Why's that? I cross-checked and the values are not blank on columns of Table A or B. Kindly help.

Probably because there are HomeLGAs with more than 1 HomeSubRegion

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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