Add Similar Column/field from different Table

[Yau0101]

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

[amitchandak · Accepted solution]

@Yau0101 ,

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

[Yau0101]

Thanks @amitchandak ,found the solution from the youtube link provided.