NATURALINNERJOIN function


Advertisements

Description

Performs an inner join of a table with another table. The tables are joined on common columns (by name) in the two tables. The two tables are to be related by one of these common columns.

If the two tables have no common column names, or if there is no relation between the two tables, an error is returned.

DAX NATURALINNERJOIN function is new in Excel 2016.

Syntax

NATURALINNERJOIN (<leftJoinTable>, <rightJoinTable>)

Parameters

Sr.No. Parameter & Description
1

leftJoinTable

A table expression defining the table on the left side of the join.

2

rightJoinTable

A table expression defining the table on the right side of the join.

Return Value

A table which includes only rows for which the values in the common columns specified are present in both tables. The table returned will have the common columns from the left table and other columns from both the tables.

Remarks

  • 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.

Example

= SUMX (NATURALINNERJOIN (Salesperson,Sales),[Sales Amount]) 
dax_functions_other.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements