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, 2019 in Power BI by anonymous

edited May 15, 2019 by Omkar 157 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, 2019 by Avantika
• 1,500 points

edited May 15, 2019 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, 2019 in Power BI by anonymous
• 32,440 points
1,968 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
• 51,830 points
111 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
• 51,830 points
468 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
• 51,830 points
74 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
• 51,830 points
72 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
• 51,830 points
103 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
• 51,830 points
100 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, 2019 in Power BI by Avantika
• 1,500 points
446 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, 2019 in Power BI by Avantika
• 1,500 points

edited May 17, 2019 by Omkar 716 views