Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Two Associations to the Same Table

I have two associations to a "user" table for two different columns in a "project" table.  I am told I need to have a different instance of "user" in order to join to a different column in the "proje...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

If you have a relationship between ttwo tables, you can use RELATED function . If  they don't have a relationship. So try to use LOOKUPVALUE.

 

Information about these two fuctions below

 

https://msdn.microsoft.com/en-us/query-bi/dax/related-function-dax

 

https://msdn.microsoft.com/en-us/query-bi/dax/lookupvalue-function-dax

 

Best Regards

Community Support Team _ Polly

 

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I'm not sure this is the solution for what I am trying to do.    I have a table that has a list of users (Users).   I have a 2nd table that has a list of projects (Projects).   I already have one relationship joining 'user.id' from the Users table, with 'created_by' from the Project table.   I now need to create a relationship using these same two tables but this time, I need to join 'user.id' from the User table to 'modify_by' from Project table.

 

Can I have two relationships with the same two tables?