retrieve values from a Non active relationship table

[jtpiazzamn]

I'm trying to pull the value of a field from a related (not active) table. 

There is an INACTIVE relationship between these two tables using the ID from Ideas Table, and the Idea ID from the Evaluation Table. 

Ideas Table

Name,

ID,   <----------this value and the Idea ID value from the Evaluation Table. 

Title,

Original Name

Evaluation Table

ID

Reviewer Name

Idea ID (same as Ideas ID from above)

Score

I want to add the Original Name field from Ideas Table to the Evaluation Table. The Idea ID from Evaluation Table will match the ID from the Ideas Table to retrieve the value for Original Name field. I don't need to "add" it to the evaluation table, but just to be able to add it to a table visualisation table using the Evaluation Table data. But if makes sense to add a calculated column to the Evaluation table thats fine. 

Thanks for your help! 

Jim

[amitchandak · Accepted solution]

@jtpiazzamn  You can get a new column in the Evaluation table

maxx(filter(Ideas, Ideas[ID] =  Evaluation[Idea id]) ,Ideas[Name])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

or use userelationship to activate join, if this a valid inactive join https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...