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!
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
|
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?