Forum Discussion
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 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.
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.
3 Replies
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.
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?
