Forum Discussion
NATURALLEFTOUTERJOIN not finding common join columns
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
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/
1 Reply
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/