Forum Discussion

ayana2's avatar
ayana2
Frequent Visitor
1 year ago
Solved

Modeling with 3 fact tables

Hey, I have a modeling challenge that I hope someone can help me resolve. I'm working with 3 fact tables and I need to create a table that draws columns from all the three fact tables. Basically, I'm...
Need Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    1 year ago

    ayana2 

    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!
tharunkumarRTK's avatar
tharunkumarRTK
Super User
1 year ago

ayana2 

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!
ayana2's avatar
ayana2
Frequent Visitor
1 year ago

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?