Forum Discussion
Power BI DAX Join error
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.
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.