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 O...
Lab 1
Lab2
Lab3
Lab4
Lab5
Lab6
Lab7
Lab8
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.