How to create a relationship between two tables using a common key

Hi,

I have three dimenstion tables as below and merged these 3 tables into one:

The merged dimension table looks like below:

similarly I have a data table as below:

Now I want to merge these above table to communications table as below:

I was able to create a relationship between communication and Data with a help of calculated column(Awesome solution from sergei baklan)

I am confused here how to merge communication with dimension table: The communication table has below columns

Now the merged dimension table contains Point id column that corresponds to point id in communication table.

Similarly the client id column in dim merged table corresponds to client id in communication table

This goes similar for contact id column. They all don't have common keys.

Now i am confused how to create a relationship between these two tables.

Can you please help me please?

Please let me know if you need further info

PFA https://1drv.ms/u/s!AhUFhM5jR1jqiipakh2A-frrJjYJ?e=00wqut

Thanks in advance

SergeiBaklan
Oct 09, 2023
Excellove15

Thank you, I only downloaded it. Could you please clarify how you'd like the relationships to work. Not for each contact you have many point, for each point many Data records and for each many communication records. You'd like for each client to show all related communications records or what?

Forum Discussion