Data Modeling

[Anonymous]

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

[ankitpatira · Accepted 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.