Forum Discussion
Still missing data after creating relationship between two tables
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
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
5 Replies
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.
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.
Thank you, bsas
I will look into merge queries
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,
AngeliaThank you, Angelia!
I really appreciate the help! I believe that solved my problem!
