DAX Function Guide

NATURALINNERJOIN
Empty image or helper icon

Sam McKay

CEO & Founder

How does the NATURALINNERJOIN 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?

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

Loading

Considerations when using the NATURALINNERJOIN?
  • 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

Loading

Formula examples using the NATURALINNERJOIN

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

= NATURALINNERJOIN(cte;cte2)

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

Related Courses

Loading