Forum Discussion
Managing Relationships
Hi There, I have two appended tables ( i also have more with the same information) with most of the columns being the same e.g. both have Name, Year, Reg etc. However I am unable to create a rela...
You want to join "Name" column right? Since "Name" is both table are not unqiue, this is a N:M relationship. Now Power BI only support 1:1 or 1:N. So what you can do in this case is to create a "Name" master table that contain all UNIQUE row of "Name". Then instead of joining "Attainment" and "Demographic", you join "attaiment" and "demographic" to the "name" master table respectively.