CODEWITHSUNDEEP
powerbidax
Marc Pincince
Marc Pincince

Reputation: 5202

How can I do a DAX naturalleftouterjoin?

I've got two tables in Power BI: GetWordCounts and CountTopN.

GetWordCounts has three columns: Columns, Columns2, and Count.

enter image description here

CountTopN has two columns: GetWordsCount_Count and Count.

enter image description here

I established a many-to-one relationship between the tables, linking the columns CountTopN[GetWordsCount_Count] and GetWordCounts[Count].

enter image description here (The related columns are both data typed as whole numbers.)

I created a new blank table and added: Table = NATURALLEFTOUTERJOIN(CountTopN,GetWordCounts).

I receive the error: The Column with the name of 'Count' already exists in the 'Table' Table.

enter image description here

I don't understand what I'm doing wrong. I'll appreciate any assistance.

Upvotes: 1

Views: 6853

Answers (1)

Marc Pincince
Marc Pincince

Reputation: 5202

I just found the answer here.

Bottom line is I had columns in each of the two tables named Count and one of them was not part of the join condition. I renamed the one in CountTopN to Count2 and the join worked.

Upvotes: 2

Related Questions