Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Lookup value from another table

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 Colu...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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.

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

thanks Jimmy excellent feedback once again