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.

jwelch176's avatar
jwelch176
Frequent Visitor
4 years ago

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?