Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.
User | Count |
---|---|
10 | |
10 | |
3 | |
2 | |
1 |