Forum Discussion
sivarajan21
Post Prodigy
Post ProdigyHow 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: ...
audreygerred
Super User
Super UserRather 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
Post ProdigyI want it merged! star schema will not work in my case
Any lead would be appreciated
Thanks in advance