Forum Discussion

Kiran_yed's avatar
Kiran_yed
Microsoft Employee
7 years ago

Power BI DAX Join error

Trying to join two tables based on a column name 'User_Id'.  'User_Id' column is present in both the tables for join purpose, but why is the below error coming? This error is same with NATURAL LEFT OUTER Join and NATURAL INNER JOIN..

Please Help! 

 

Thanks,

Kiran

Lab 1
Lab2
Lab3
Lab4
Lab5
Lab6
Lab7
Lab8

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    Right, so oddly enough you can't have columns with the same names when joining tables in DAX. You usually use something like SELECTCOLUMNS to not change the names of the columns (trust me, it doesn't make sense but it works). This is explained very well in Phil_Seamark 's book, Beginning DAX with Power BI on pages 118-121.

    • Kiran_yed's avatar
      Kiran_yed
      Microsoft Employee
      7 years ago

      Thanks Greg, But can you tell me how does NATURALINNERJOIN work in my situation. what's the use of NATURALINNERJOIN and NATURAL LEFT OUTER JOIN, 

      my sample table schema:

      Table1: Partner_ID, User_Id

      Table2: User_Id, User_Name,UserEmailId

      can you please tell me how to inner join these two tables on User_Id?

       

       

      Thanks in advance

      Greg_Deckler wrote:

      Right, so oddly enough you can't have columns with the same names when joining tables in DAX. You usually use something like SELECTCOLUMNS to not change the names of the columns (trust me, it doesn't make sense but it works). This is explained very well in Phil_Seamark 's book, Beginning DAX with Power BI on pages 118-121.