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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

pedroccamara Can you provide an example? Are you going to import the data or use a different connection type like direct query to these sources? If you import the data into Power BI Desktop, there are a bunch of ways you can merge, clean up your data set to display how you want it.

  • pedroccamara's avatar
    pedroccamara
    Helper II
    10 years ago

    Hello Eno and many thanks for your help.

    The problem is that i have 2 identical fields from a table. Both are showing usernames and i have a table to relate to both. Power bi "said" i can't do it. Either one field or the other. Not both. My question, cose i'm running out of ideas, how to do it in other way?

    Many thanks

    Best regards

    Pedro