Forum Discussion

samsha786

Helper I

6 years ago

Solved

DAX NATURALINNERJOIN

My code: Resource Allocations = VAR AssignedCapacityWeighted = SELECTCOLUMNS( SUMMARIZECOLUMNS( ...

Need Help

amitchandak

6 years ago

NATURALINNERJOIN as per documentation

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

https://docs.microsoft.com/en-us/dax/naturalinnerjoin-function-dax

Refer how to use : https://www.youtube.com/watch?v=mcQ_ZmuWvDs&vl=en

there is a costly option

filter(crossjoin(table1,table2), Table1[A]=Table2[B])

Try in edit query

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

amitchandak

Super User

6 years ago

NATURALINNERJOIN as per documentation

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

https://docs.microsoft.com/en-us/dax/naturalinnerjoin-function-dax

Refer how to use : https://www.youtube.com/watch?v=mcQ_ZmuWvDs&vl=en

there is a costly option

filter(crossjoin(table1,table2), Table1[A]=Table2[B])

Try in edit query

https://radacad.com/append-vs-merge-in-power-bi-and-power-query