Forum Discussion
Advocate Inaturalleftjoin DAX error at-least one common join column
Hi ahuhn,
You can make typecasing explictly in Power Query for common column i.e. at the time of loading of data using M formula.
OR
Below is the solution that i can think and suggest your. If NATURALJOIN is not able to match columns types for common column in "NOW" and "BEFORE" table, you need to make data type compatible explictly.
Below is the workaround -
Assuming that common column is "Name" and Relationshipt is in place.
NATURALINNERJOIN(
SELECTCOLUMNS('NOW',"Name",NOW[name]&"",<add another name , column as required>) ,
SELECTCOLUMNS( 'BEFORE',"Name",BEFORE[name]&"",<add another name, columns as requierd)
)
Hope it should resolve this issue.
Thanks,
Amit Dhiman
- QuinnP
Advocate II
One issue I had with this is that I was attempting to use a natural join on a temporary table within a measure and another table. I had to do all my joining as my first step, because once a temporary table was created, the relationship that the original tables had that the natural join would be performed on was lost.
Hope this helps anyone in a similar situation!
I'm having the same issue here.
I have a static timeseries table that looks like this Date, ID, Value
I need to "filter" it into 2 tables using the endpoints of a slicer.
SData & EData are the result of this filtering using CalculateTable.
Both get their respective data points & nothing else.
Then I need to use "full join" on both SData & EData using ID as the join point.
This is where I got tripped up.
Certainly, I could do this in SQL readily but I need to dynamic aspect of the above if it works.
giramswaHelper II
Thank you, this was helpful to fix the error without having to rename the columns.
