Relating 3 fields to a single table

[lcasey]

Hello,

I have 3 fields in my table called BSAContracts that contain a user ID.  I am trying to display the UserName so I have another table called User Information List that contains the user ID and name.  I had to replicate it 2 times which significantly increases my .pbix size.

Is there any way I can return the Names from the User Information List table without duplicating that table two other times?

[lcasey · Accepted solution]

I deleted all releationships to the User Information table and performed a lookup and that worked:

Contract Signer = LOOKUPVALUE('User Information List'[EMail], 'User Information List'[Id],BSAContracts[ResponsibleId])

This looks up the User ID in the people Picker field of SharePoint and returns the email address for all matching ResponsableID's.

I created 3 additional columns in the table that performs this lookup.

No more duplicated tables needed:

[v-ljerr-msft]

Hi @lcasey,

Great to hear the problem got resolved! Could you accept your reply as solution to help others who has similar issue easily find the answer and close this thread?

Regards