Relationship help

[Keiser]

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 data with the exception of dates. Im looking to do a page for craft and a page for staff. and then a summary page which show craft cost and staff cost togather. I cannot get the two data sets to combine to show up in a matrix table. can anyone help?

[lbendlin · Accepted solution]

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?