Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The columns on the far right of each table are what they have in common:
But I'm having a hard time connecting the two since the seond table has multiple values due to multiple revenue dates I'm guessing:
How can I successfully connect the two?
Solved! Go to Solution.
You can't create a relationshipship between the columns that doesn't have unique values atleast either of one. In this case I will try to bring in unique values in atleast one in either of the columns or I would build a Bridge table in between these two tables which contains only the unique values of the Joing column then you can create a relationship like this lefttable(* -1) Bridge table (1-*)Righttable.
You can't create a relationshipship between the columns that doesn't have unique values atleast either of one. In this case I will try to bring in unique values in atleast one in either of the columns or I would build a Bridge table in between these two tables which contains only the unique values of the Joing column then you can create a relationship like this lefttable(* -1) Bridge table (1-*)Righttable.
@Anonymous you are exactly right. I actually JUST figured it out a few moments ago. Thank you!
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |