Forum Discussion

pedroccamara's avatar
pedroccamara
Helper II
10 years ago
Solved

Relate same table twice

Hello I have a problem and still don't know how to solve it. The main db has two fields with the same data. It is a username of the person whatever. And i have another db that has all usernames and...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    pedroccamara

     

    We cannot make two relationships active at the same time for two tables here. Using an inactive relationship is a way. This article should be a good reference.

    Actually, we don’t need two relationships in some situations. As dejanle posted above, if we have two tables as below. We can create a relationship between Sell-to_Customer_No and Customer_No to get Sell-to Custome_Name.

     

    We can also get Bill-to_Customer_Name by creating a column using LOOKUPVALUE without relationship.

    Bill Customer Name = 
LOOKUPVALUE ( DB2[Customer_Name], DB2[Customer_No], DB1[Bill-to_Customer_No] )

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

pedroccamara

 

We cannot make two relationships active at the same time for two tables here. Using an inactive relationship is a way. This article should be a good reference.

Actually, we don’t need two relationships in some situations. As dejanle posted above, if we have two tables as below. We can create a relationship between Sell-to_Customer_No and Customer_No to get Sell-to Custome_Name.

 

We can also get Bill-to_Customer_Name by creating a column using LOOKUPVALUE without relationship.

Bill Customer Name = 
LOOKUPVALUE ( DB2[Customer_Name], DB2[Customer_No], DB1[Bill-to_Customer_No] )

 

Best Regards,

Herbert

pedroccamara's avatar
pedroccamara
Helper II
10 years ago

Many thanks for your answer.

Gonna try with vlookup

 

Best regards

Pedro