Forum Discussion
Relationship between two tables
Hi Please if anyone can help me to make relationship between two tables as shown in the attached pictures , it is always give me messages as (many to many) but I need to be relationship (Many to one...
Dear Mr. Idressshatila
Yes the table : functionallocationID, has too much duplicate. It is big data more than 7500 rows.
so please how to make relationship be many to one
in order to be one to many, the table should have a distinct value of the id that you are making the relationship with.
in your case you should have a middle table with distinct functionallocationID that connect with both of these tables.
check the concept of star schema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
