NaturalLeftJoin throws "No Coemmon join columns detected" error. Column names in 2 tables are same

[mikebreen]

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:

z_Natljoin = NATURALLEFTOUTERJOIN(z_DaysInWeek1, z_DaysInWeek2)

I'm familiar with: NATURALLEFTOUTERJOIN function (DAX) - DAX | Microsoft Docs

[v-xiaoyan-msft]

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