NATURALLEFTOUTERJOIN is a DAX function that joins two tables using left outer join semantics based on common columns.
NATURALLEFTOUTERJOIN(
LeftTable,
RightTable
)| Argument | Properties | Description |
|---|---|---|
| LeftTable | The Left-side table expression to be used for join. | |
| RightTable | The Right-side table expression to be used for join. |
A table which includes only rows from RightTable for which the values in the common columns specified are also present in LeftTable. The table returned will have the common columns from the left table and the other columns from both the tables.
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.
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 (have the same lineage) are joined on. For example, Products[ProductID], WebSales[ProductdID], StoreSales[ProductdID] with many-to-one relationships between WebSales and StoreSales and the Products table based on the ProductID column, WebSales and StoreSales tables are joined on [ProductID].
Strict comparison semantics are used during join. There is no type coercion; for example, 1 does not equal 1.0.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Other functions related to NATURALLEFTOUTERJOIN are:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy