Forum Discussion
Copy value from one table to another on matching IDs
Gotcha, this one is pretty straightforward. I am using names that are different than yours for clarity, but this is how you will do it:
1. Create a relationship between 'Header_Table'[ID_Number] and 'Detail_Table'[ID_Number]
2. Add a column to 'Detail_Table' with the formula ID Number = RELATED('Header_Table'[Type])
Let me know if you have any questions.
I would like to add the "Type" column to the detailed table. In the example that would be "A" and "B".
Resolver IIGotcha, this one is pretty straightforward. I am using names that are different than yours for clarity, but this is how you will do it:
1. Create a relationship between 'Header_Table'[ID_Number] and 'Detail_Table'[ID_Number]
2. Add a column to 'Detail_Table' with the formula ID Number = RELATED('Header_Table'[Type])
Let me know if you have any questions.