Hi I've tried to use NATURALINNERJOIN and NATURALLEFTOUTERJOIN but their behaviour appears to me in contrast with the official documentation NATURALINNERJOIN function (DAX) - DAX | Microsoft Learn :...
Hi MACHI ,
NATURALINNERJOIN & NATURALLEFTOUTERJOIN both DAX functions are used to perform the joins between two tables, these functions comes under Table manipulation functions category.
- Columns being joined on must have the same data type in both tables.
- The names of the columns that define the relationship need to be different.
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].
You may check this to help you to have a better understand.
NaturalInnerJoin and NaturalLeftOuterJoin DAX Functions - Power BI Docs
Best Regards,
Community Support Team _ Caitlyn