Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |