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 1,134 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 EdurekaUser
• 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,970 points
10,183 views
0 votes
1 answer

how to write dax calculation Power bi

Hi, @vnk You can make use of this ...READ MORE

answered Aug 5, 2020 in Power BI by code_Damon
184 views
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,930 points
271 views
0 votes
1 answer

How to create a Measure using Power BI DAX?

The following steps make your task simple ...READ MORE

answered Oct 27, 2020 in Power BI by Gitika
• 65,930 points
110 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
• 52,370 points
255 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
• 52,370 points
207 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
• 52,370 points
280 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 EdurekaUser
• 1,500 points
1,128 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 EdurekaUser
• 1,500 points

edited May 17, 2019 by Omkar 4,831 views