NATURALINNERJOIN Function (DAX) - Enterprise DNA | Knowledge Base

NATURALINNERJOIN

NATURALINNERJOIN Function (DAX)

Sam McKay February 12, 2020 No Comments

How does the NATURALINNERJOIN function (DAX) work?

The NATURALINNERJOIN function (DAX) performs an inner join of a table with another table. The tables are joined on common columns (by name) in the two tables. If the two tables have no common column names, an error is returned.

NATURALINNERJOIN Formula Syntax

NATURALINNERJOIN (
<leftJoinTable>, <rightJoinTable>
)

How do you use the NATURALINNERJOIN function?

The join condition of NATURALINNERJOIN is automatically defined by the columns having the same name and type in the two tables. You use this function when you do not have a relationship in the data model between two tables, and you can join the result of table functions.

Related Blog Posts

Related Support Forum Posts

Using InnerJoin
Joining Two Calculated Tables
New Table using DAX or M? Or only by Query Edit?

Considerations when using the NATURALINNERJOIN function

There is no sort order guarantee for the results.
Columns being joined on must have the same data type in both tables.
Only columns from the same source table are joined on.
Strict comparison semantics are used during join. There is no type coercion.

Related Video Tutorials

Formula examples using the NATURALINNERJOIN function

= SUMX (NATURALINNERJOIN (Salesperson,Sales),[Sales Amount])

= NATURALINNERJOIN(cte;cte2)

= ADDCOLUMNS( NATURALINNERJOIN( ‘Table 1’, SUMMARIZE( ‘Table 2’, ‘Table 2′[closing balance] )

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

“I truly appreciate your efforts in helping the ones who needed to get more professional help in using Power BI. Your videos are A+ and really helpful+inspiring for me. I wish you the best from Turkey.”

Erol Yücel

“I have taken couple of courses from Sam from Enterprise DNA. I really liked the course. Its well explained, organized and importantly all the datas and formulas & even dashboards are available for everyone.”

Mahesh T, London

“Enterprise DNA has greatly increase my ability to report within our company forever. I went from knowing nothing about Power BI to using it on a daily basis in 30 days simply by watching Sam’s videos & executing his technique.”

Geoff Ellis

“Sam has a very hands-on approach to his training, and is always willing to help! Been apart of several different DAX classes, & Sam’s training is by far the best I have come across.”

Matt Ballinger

“I am really thankful to Sam for helping me through the Power BI. I was a newbie and his hands-on approach and business-oriented approach is all we need. Great work Sam. Keep going!”

Sourabh

“Thanks to Enterprise DNA training! I have improved my Power BI tool skills and have a deeper understanding of data analytics. Sam does an excellent job teaching and problem-solving.”

Brian Marron