Still missing data after creating relationship between two tables

[maximus1]

Hello Everyone

I have two tables Contractor Expense and GVC Expense. I have created a relationship between them.  My data table pulls all the information correctly from the GVC Expense data, but it is missing some information from the Contractor Expense data.

I know I am missing job code 11 ( I created it in excel first). This, I believe is because job code 11 ONLY shows up in the Contractor Expense data but not in the GVC Expense data. How can I get my table to pull ALL the info from both tables?

I've created  the following relationship:

GVC Expense: Cardinality - Many to one; Cross filter direction - Both

Contractor Expense -  Many to one; Cross filter director - Single.

Link to data:

https://www.dropbox.com/s/h4l0navz5cci1sf/Labor%20Expense.pbix?dl=0

[maximus1]

This is what my total invoice column SHOULD look like, but when I combine it with my other table. This one particular item, job code 11, does not show up.

[v-huizhn-msft · Accepted solution]

Hi @maximus1,

Because the relationship between 'GVC Expense' and 'Contractor Expense' is n:n, so the code 11 is missing. Please try use the [Job code query] in 'Job code' table, other fields come from ' Contractor Expense', and check if it works fine.

For merging two tables to one in Query Editor, please review the detailed steps here. 

Best Regards,
Angelia

[maximus1]

Thank you, Angelia!

I really appreciate the help! I believe that solved my problem!

[bsas]

Hi,

You can use "MergeQueries" (merge 2 tables into1) choose table with more data as main. In this can you'll receive one big table with all mathced data.

Suggest to watch some tutorial before using this feature.

[maximus1]

Thank you, bsas

I will look into merge queries