Create relationship with duplicate values

New Member

6 years ago

Sorry for the late response. I haven't rued many to many.

Below are three tables, one is Client loc data and another one is offshore location data and combined information data. I would like to check the discrepancy in hours at each location. so I'm trying to create a relationship with "combined table" col "Emp id -OL" to "Offshore location" col "Emp id -OL" & "combined table" col "Emp id -CL" to "Client location" col "Emp id -CL". while creating this its throwing an error stating that " you cant create relationship".

Combined table		Client Location	Offshore Location
Table 1		Table 2	Table 3
Emp ID-OL	EMP ID - CL	Name	EMP ID - CL	Name	hours	Emp ID-OL	Name	hours
40056	5727812	John	5727812	John	40	40056	John	54
40026	5824960	Pat	5824960	Pat	40	40026	Pat	40
	5844808	John1	5844808	John1	0	40020	Pat1	36
40020	6682456	Pat1	6682456	Pat1	40	40070	Nick	35
40070	7748300	Nick	7748300	Nick	40	40141	Sam	40
40141	8579674	Sam	8579674	Sam	27	40116	Ram	40
40116	8579958	Ram	8579958	Ram	28	40069	chrsty	40
40069	8641880	chrsty	8641880	chesty	44	40006	Carrie	0
40006	8641881	Carrie	8641881	Carrie	0	40034	Nick2	36
	8641883	Kirsten	8641883	Kirsten	40	40083	Sam1	40
40034	8641885	Nick2	8641885	Nick2	40	40023	Ram1	40
40083	8641890	Sam1	8641890	Sam1	40	40126	chrsty1	35
40023	8641896	Ram1	8641896	Ram1	40	40133	Carrie2	42
40126	8641900	chrsty1	8641900	chrsty1	40	40096	kisrsten1	36
40133	8641902	Carrie2	8641902	Carrie2	42	40036	Nick1	40
40096	8641903	kisrsten1	8641903	kisrsten1	36
40036	8641906	Nick1	8641906	Nick1	36

Forum Discussion

Related content

Creating relationships

Creating Relationships with duplicative values

Can't create relationship due to duplicate values (even after removing duplicates in Power Query)

Relationship

Duplicate values when creating one to many relationship in Power Bi