Finding a common relationship ID between tables

Question

Hello,&nbsp;i need to create a relationship between 2 of my tables "System users" and "Phonecalls" to see how many phonecalls each user is making. However neither of the tables have an ID value that is the same that i can tie them together with.&nbsp;I've tried using "System user name" from the system user table and linking this to the "Phonecall Name" value from the phonecall table which does work provided the names dont come through cached in the "Phonecalls" table. I'm finding at the moment that because some users name are coming through cached, the relationship is not working.&nbsp;&nbsp;&nbsp;can anyone give me an insight into how to resolve this?&nbsp;thanks!

v-cherch-msft · Answer

Hi&nbsp;KGreen12&nbsp;You may have a look at below articles. If you need further help, please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.&nbsp;https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationshipshttps://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationshipshttp://radacad.com/what-is-the-direction-of-relationship-in-power-bi&nbsp;Regards,Cherie

Forum Discussion

Finding a common relationship ID between tables

1 Reply

Related content

tool to find measures relationship

Relationship

Relationships

Relationship Issue

Creating relationships