Why is not Function SubstituteWithIndex() able to detect common columns?

Hi yaowen 

Thanks for reaching out to us.

>> Why is not Function SubstituteWithIndex() able to detect common columns between its operands that could be used for join?Please guide and prompt the reasons for such errors. 

-

In my opinion, according to the definition of SubstituteWithIndex(), "it returns ...of the two tables supplied as arguments", so we need to pass 2 tables as arguments to it. In INDEX2, you defined a virtual table _Product, however, in INDEX1, there is only one table.  So I guess that's why it's giving an error. 

FYI: SUBSTITUTEWITHINDEX function (DAX) - DAX | Microsoft Docs

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.