topic Re: Add Similar Column/field from different Table in DAX Commands and Tips

Add Similar Column/field from different Table

Anonymous — Tue, 09 Nov 2021 07:33:59 GMT

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

Re: Add Similar Column/field from different Table

amitchandak — Tue, 09 Nov 2021 09:00:11 GMT

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

Re: Add Similar Column/field from different Table

Anonymous — Wed, 10 Nov 2021 07:37:51 GMT

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