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

[sivarajan21]

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.

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 Communications (3).pbix

Thanks in advance!

@Ahmedx @Greg_Deckler @Ashish_Mathur @amitchandak 

[audreygerred]

Rather than trying to merge tables together to form one table, I would follow Star Schema and leave your fact and dimension tables separate, but joined with a relationship: http://powerbiwithme.com/2023/07/30/the-star-schema-edition/

[sivarajan21]

I want it merged! star schema will not work in my case

Any lead would be appreciated

Thanks in advance