Forum Discussion
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
Thanks in advance!
2 Replies
- audreygerredSuper User
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/
- sivarajan21Post Prodigy
I want it merged! star schema will not work in my case
Any lead would be appreciated
Thanks in advance