Sample Table Used Here:
Table1: Partner_ID, User_Id
Table2: User_Id, User_Name,UserEmailId
According to this, you can't have columns with the same names when you try joining tables in DAX.
You need to use different syntax like SELECT COLUMNS to not change the names of the columns