Forum Discussion
Create a single table many to many relationship using DAX
Hi all, I want to create single table out of two tables with many to many relationship using DAX , LOOKUP and RELATED does not work. For time being i have created relationship between them but i...
Hi Olgad , thanks for the response , it gives the below message
The Column with the name of 'PERSON' already exists in the 'Table' Table.
It is because PERSON is present in both tables?
Yes, please rename it first and check if it works, are there any other columns with the same name in both tables? In this case they will give you the same problem.
When we do selectcolumns, we specifically say which columns to take, but when not, there cannot be the columns with the same name. In Power Query such columns will automatically get Person.1 name
