Forum Discussion
Solved
Shared value from two different columns put into one
Hello I am combining notes from two different data sources and want to group rows based on a shared ID to combine the notes from these sources. In one table it is called 'objectid' and in the other i...
Create a bridge table that unions both ID columns:
Combined IDs =
DISTINCT(
UNION(
SELECTCOLUMNS(Table1, "ID", Table1[objectid]),
SELECTCOLUMNS(Table2, "ID", Table2[regardingobjectid])
)
)Relate both original tables to this bridge table. Then create a measure that combines notes from both tables using the shared ID relationship.
If this answer helped, please click Kudos or mark as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande
v-aatheeque
Community Support
Community SupportHi docs
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.
Yes they did. Thank you for your help!