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 you might already know, Power BI best suits for start schema and relating two fact tables deveiates your modelling from start schema. This will make your dax measures complicated and can cause performance issues. I went through the pbix and could you share the expected result?
I will try to build the same and can share it with you
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
For some reason It's not allowing me to add a table. See if you can access this sample file on Google drive: https://docs.google.com/spreadsheets/d/1MAv9ibPjwUARPnNhwXAj4BgCs7wbABMJsynSve50Ooo/edit?usp=sharing
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!
Thank you! I do see you have the kind of a table I want but then I don't see the solution. I guess what I'm looking for is how to get where you got. For instance, how did you filter the worked hours from a many-to-many relationship so that they can display correctly?