Lookup value from another table

[Anonymous]

Hi Experts

Not sure whats the best route tp tackle this, either via a lookup or related or related table function. I have two tables.

Table A Columns

Country_NM

Country_ISO_CD

Table B Columns

Country_Origin_ISO_CD

Country_Origin_NM

I want to lookup/Match from Table B Country_Origin_ISO_CD with column Country_NM in Table A and what the result is in Column Country_ISO_CD in Table A return that into a new column in Table B Country_Origin_NM.

[jwelch176]

I've tried this, unsuccessfully, in Power Bi Desktop Version: 2.103.881.0 64-bit (March 2022).  Does the query or formatting need to be changed since the solution is about 2 years old?

[v-yuta-msft · Accepted solution]

@Anonymous ,

You can create a measure in TableB using DAX below:

Column =
LOOKUPVALUE (
    TableA[Country_ISO_CD],
    TableB[Country_Origin_ISO_CD], TableA[Country_NM ]
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

thanks Jimmy excellent feedback once again