Forum Discussion
Relate same table twice
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
You can create 1 active and many inactive relationship.
After when i need to use a inactive relationship just put in dax USERELATIONSHIP(Table1[Colum], Table2[Column])
Hope this can help you
Hi Vvelarde
Thanks for your answer.
The problem is that i don't know where and how to use it. Everyday your database is growing and it's simple for me to refresh it and it's updated. I've miss the dax lesson also.
Best regards
Pedro
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
Many thanks for your answer.
Gonna try with vlookup
Best regards
Pedro