Forum Discussion
Data Modeling
Each fact table will connect to the dimension tables, then you will use the fields from your dimension tables with your measures based on your fact tables. Here is a blog I wrote about star-schema (my example only has one fact table, but it is applicable to having multiple fact tables as well). http://powerbiwithme.com/2023/07/30/the-star-schema-edition/
Yep - understand that...but what is the best way to make relationships when you have multiple Fact tables? How do you get everything connected? Example --> Fact Table to Fact Table
Each fact table will connect to the dimension tables, then you will use the fields from your dimension tables with your measures based on your fact tables. Here is a blog I wrote about star-schema (my example only has one fact table, but it is applicable to having multiple fact tables as well). http://powerbiwithme.com/2023/07/30/the-star-schema-edition/