Forum Discussion
Modeling with 3 fact tables
As you can see I added few columns that you asked for, and these coulumns cover all three fact tables. Its just that you need to perform the aggregation appropriately
I am atttaching the pbix for your reference
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
As long as you do the modelling properly, having three fact tables wont be a big challenge. Relate employee and date dimension tables with with three fact tables. Perform the aggregations on fact table properly. You can checkout this video for more info.
https://www.youtube.com/watch?v=TnyRsO4NJPc
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
Thank you tharunkumarRTK . I have related employee and date dimension tables with with three fact tables already. The problem is relating the three fact tables-so I'm having issues with aggregations when the relationships between the fact tables are not well defined. That's the issue I was hoping to get help with. I have watched a couple of videos including the one you shared and while it seems rather straightforward, when I create the bridge tables, I still cannot fetch some columns. I believe the issue is inability to define the bridge tables properly. And that's what I need help with.