Forum Discussion
ahuhn
Advocate I
Advocate Inaturalleftjoin DAX error at-least one common join column
I have two tables I am trying to perform a NATURALLEFTOUTERJOIN together based no the common column, 'name', but am receiving an error. 'No common join columns detected. The join function 'NATUR...
TimoRiikonen
Advocate V
Advocate VLet's add couple of more requirements to Chihiro's list:
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.
3. Natural joins don't work for DirectQueries. So then you need to use CrossJoin instead. Remember to still rename matching columns differently from each other.
4. DirectQuery must have less than a million rows.
Helpful! Thanks
