Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 ,
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
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |