Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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?
@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.
thanks Jimmy excellent feedback once again
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |