Forum Discussion
Add Similar Column/field from different Table
Dear All,
I have two tables, 1st table name "Deals" and 2nd table name "Deals Product". In "Deals" table its has column named "Stage_Id". I want this column "stage_id" to be in "Deals Product" table. How can i do that? Please advise. Thanks
Please see the screen captures below:
1. Deals table
2. Deals Product table
Anonymous ,
a new column in deal product
Stage = maxx(filter(Deal, deal[ID] = 'deal product'[Deal ID]) , Deal[Stage Id])
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
2 Replies
Anonymous ,
a new column in deal product
Stage = maxx(filter(Deal, deal[ID] = 'deal product'[Deal ID]) , Deal[Stage Id])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8Thanks amitchandak ,found the solution from the youtube link provided.