Forum Discussion

sivarajan21's avatar
sivarajan21
Post Prodigy
2 years ago

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.

 

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