Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Relationship help

Hello, I very new to Power BI. Im trying to connect to different data sheets. One is an estimate for Craft cost and the other is for staff cost. The do not have any keys between them to connect the d...
relationship
  • lbendlin's avatar
    lbendlin
    4 years ago

    Think about the nature of your data. Power BI likes to see dimension tables and fact tables.  Dimensions are things that you can use for filtering and they are usually unique (like an employee dimension or a date dimension).  Facts are thing that you can calculate and they are usually repeated (not unique by themselves)

     

    Your scenario seems to be a bunch of dimension tables. I can't see where you have actual facts. 

     

    Eventually you can shape your data model according to the business question you are trying to answer.  When you show crafts and employees together on a page, what is the overarching theme?  is it a time progression chart? is it a mapping chart between the dimensions?

lbendlin's avatar
lbendlin
Super User
4 years ago

Think about the nature of your data. Power BI likes to see dimension tables and fact tables.  Dimensions are things that you can use for filtering and they are usually unique (like an employee dimension or a date dimension).  Facts are thing that you can calculate and they are usually repeated (not unique by themselves)

 

Your scenario seems to be a bunch of dimension tables. I can't see where you have actual facts. 

 

Eventually you can shape your data model according to the business question you are trying to answer.  When you show crafts and employees together on a page, what is the overarching theme?  is it a time progression chart? is it a mapping chart between the dimensions?