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.
Table 1, Table 2 and Table 3. Table 1 Col A values are there in Table 2 Col D & Table 1 Col B values are there in Table 3 Col F. While creating relationship from Table 1 Col A to Table 2 Col D it through an error as " You cant create relationship b/w these two columns because one of the columns must have unique values."
40056 | 5727812 |
These are Emp id 's ..40056 is the emp id of Mr. John at x location and 5727812 is the emp id of Mr. John at y location.
If there is a case like
5844808 |
Mr. Peter is there only y location he doesn't have any presence in x location.
I need to figure out respective timesheet hours for each location. Because of duplicate values (spaces in Col A) we are not able to create relationships. Is there any way to create a relationship without disturbing null values in Col A.
Col A | Col B |
40056 | 5727812 |
40026 | 5824960 |
5844808 | |
40020 | 6682456 |
40070 | 7748300 |
40141 | 8579674 |
40116 | 8579958 |
40069 | 8641880 |
40006 | 8641881 |
8641883 | |
40034 | 8641885 |
40083 | 8641890 |
40023 | 8641896 |
40126 | 8641900 |
40133 | 8641902 |
40096 | 8641903 |
40036 | 8641906 |
8724484 | |
8759290 | |
40172 | 8927885 |
40179 | 9075208 |
40177 | 9103880 |
40148 | 9248492 |
40015 | 9413296 |
40191 | 9539589 |
40190 | 9603935 |
40131 | 9607819 |
40286 | 9819773 |
40157 | 9953113 |
40043 | 9985248 |
40206 | 10135515 |
40207 | 10283765 |
40031 | 10312927 |
10385152 | |
40101 | 10390129 |
40007 | 10430151 |
10494417 | |
10504100 | |
40230 | 10838291 |
10935299 | |
40228 | 11048208 |
40243 | 11434183 |
40237 | 11545951 |
40232 | 11558252 |
40242 | 11592590 |
40249 | 11667068 |
40009 | 11791433 |
40106 | 11795195 |
11813937 | |
11820039 | |
40241 | 11838266 |
40047 | 11905631 |
40256 | 11916950 |
40029 | 11950228 |
40259 | 12003626 |
40134 | 12027900 |
40261 | 12081304 |
40075 | 12134235 |
40264 | 12268980 |
12378898 | |
40267 | 12451986 |
40030 | 12496831 |
40280 | 12540564 |
40281 | 12543419 |
40279 | 12548239 |
40282 | 12579915 |
40119 | 12677895 |
40284 | 12724499 |
40104 | 12747173 |
Hi @challarajes82 ,
Can you give me a sample of Col D? I can't reproduce your question for lack of it. And have you tried Many-to-Many relationship?
Best Regards,
Icey
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 |
Hi @challarajes82 ,
I'm sorry to response late. Based on my test, you can only create 'Many-to-Many' relationship between "combined table" and "Offshore location".
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
99 | |
97 | |
85 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |