Microsoft EmployeeNaturalLeftJoin throws "No Coemmon join columns detected" error. Column names in 2 tables are same
NaturalLeftJoin does not work even though the column names in 2 tables are the same "DateKey" and same data type of text
As additional troubleshooting, in the Model view, there is a message that the table I'm trying to setup with NatualLeftJoin is already present:
This is the DAX code for the table:
1 Comment
Hi mikebreen ,
You need to have columns that define joins named differently.
It is counter intuitive, but in order for the function to work.
1. Relationship between column(s) defining join must be set before the function can be used.
2. Related column must have different name between two tables being joined.
Please check out some of the solutions given by other users in this similar thread.
naturalleftjoin DAX error at-least one common join column
Best Regards,
Community Support Team _ Caitlyn
