naturalleftjoin 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