How to resolve Power BI DAX Join error?

+1 vote

I am trying to join two tables which are based on a column name 'User_Id' for both the columns  

'User_Id' column is present in both the tables, but unfortunately, an error is popping up.

This error is occurring at the same time ie NATURAL LEFT OUTER Join and NATURAL INNER JOIN.

How do I resolve this?

May 14 in Power BI by anonymous

edited May 15 by Omkar 76 views

1 answer to this question.

+1 vote

Sample Table Used Here:

Table1: Partner_ID, User_Id

Table2: User_Id, User_Name,UserEmailId

According to this, you can't have columns with the same names when you try joining tables in DAX. 

You need to use different syntax like SELECT COLUMNS to not change the names of the columns 

answered May 14 by Avantika
• 1,500 points

edited May 15 by Omkar

Related Questions In Power BI

0 votes
1 answer

How to rename a column using DAX in Power BI?

Hi Ramya, I found these two function that ...READ MORE

answered Aug 21 in Power BI by anonymous
• 31,840 points
303 views
0 votes
1 answer

How to assign Power BI license to a new user

The assign license method of MS Graph API might ...READ MORE

answered Sep 25, 2018 in Power BI by Kalgi
• 42,330 points
69 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 42,330 points
290 views
0 votes
1 answer

How to add an image to power bi report – power bi web

There are visuals (e.g. table) that can ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 42,330 points
47 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 42,330 points
51 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 42,330 points
84 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 42,330 points
63 views
+1 vote
1 answer
0 votes
1 answer

How To use R Integration in Power BI?

Hi,  There are a lot of packages available ...READ MORE

answered May 2 in Power BI by Avantika
• 1,500 points
174 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered May 17 in Power BI by Avantika
• 1,500 points

edited May 17 by Omkar 96 views