Forum Discussion
Help working with linked data from two SQL databases in Direct Query mode
I am working from 2 SQL server sources using DirectQuery. In SQL server A, Event_ProductID is an integer, and in SQL Server B, "productID" is a string but it should be a matching field between the tw...
What I was really looking for was the function LOOKUPVALUE. All sorted now, thanks!
Anonymous
For many to many relationship, only RELATEDTABLE function (DAX) - DAX | Microsoft Docs function. If you want to use RELATED function (DAX) - DAX | Microsoft Docs, you may create a mid table using distinct([column]), then link both tables to the mid table with 1 to many relationship.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.