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.
Hi
I would like to ask how to solve my problem
I have a two tables :
How can I create a relationship between the two table? Power BI doesnt allow me to use invoice_id because it should be unique. I need to fix it because if I join the tables via SQL query it makes double the value of invoice_amount and contract_amount on the graphs
Please advise. Thank you!
Regards,
Arvin
Solved! Go to Solution.
@Anonymous For you to be able to create relationship between two tables you certainly need unique values in one column much like PK FK relations. So if values in your table 1 are not unique you should via query editor remove duplicate values and then create relation from table 1 to table 2.
@Anonymous For you to be able to create relationship between two tables you certainly need unique values in one column much like PK FK relations. So if values in your table 1 are not unique you should via query editor remove duplicate values and then create relation from table 1 to table 2.
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |