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

[nchand]

Hi,

I have the table A with the following cols : 

And Table B with following col: 

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

[AlB]

@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

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 · Accepted solution]

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.

[nchand]

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.

[sturlaws]

Probably because there are HomeLGAs with more than 1 HomeSubRegion