Forum Discussion
Many-One Relationship when there are Unique values in both tables
I am attempting to link togther two tables that both have unique values, however, it is not allwoing me to make a one:one relationship- instead making a many:one relationship. I have checked in E...
Hi Anonymous ,
This is due to the design, and one-to-one relationships are not supported when there are duplicate values in the table.
You can use the values() function or the distinct() function to create a table with deduplicated values. Then establish a one-to-one relationship with the new table.
Please refer to my PBIX file.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
I created a new table using Value Function and Distinct Function respectively and it is still not allowing me to create one:one relationship with either of the calculated tables