The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have table 1 with a unique key called [Member ID]
Table 1 does not include [Country]
Table 2 has [Member ID] and [Country]
I want to pull the values in [Country] from table 2 into table 1 using [Member ID]
Can you help?
Solved! Go to Solution.
@Anonymous
Assuming the 2 tables are related by Member ID, try this column
= CONCATENATEX ( RELATEDTABLE ( Table2 ), Table2[Country], "," )
@Anonymous
Assuming the 2 tables are related by Member ID, try this column
= CONCATENATEX ( RELATEDTABLE ( Table2 ), Table2[Country], "," )
User | Count |
---|---|
87 | |
84 | |
36 | |
35 | |
30 |
User | Count |
---|---|
96 | |
74 | |
67 | |
52 | |
51 |