NATURALLEFTOUTERJOIN not finding common join columns

[Anonymous]

Hi everyone,

I'm testing the NATURALLEFTOUTERJOIN function with the below tables no success, receiving a "No common join columns detected. The join function 'NATURALLEFTOUTERJOIN' requires at-least one common join column." error.

Both are configured as date tables with no relationship to each other in the data model.

Any ideas why I might be receiving this error?

NATURALLEFTOUTERJOIN('Calendar Table', 'Calendar Table2') is what I'm using in my measure

[MFelix · Accepted solution]

Hi @Anonymous ,

Check this blog post of SQLBI they have the error in question detailed.

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/