Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |