Merging queries

[CMSGuy]

I have three separate queried lists: Detail, Hours, Ratings.  All of these lists have a common EmployeeID.  What I want to happen is to merge the queries together by date (data is filtered by employee on the report itself).  Some tables might not have any information for any given date, where another might have some data.  So if there is data for May 15 in the ratings table, but not the Detail table nor the Hours table, I need to make sure that there is ONE entry for May 15 that shows the ratings data.  There also is only ONE date for each flattened record (if that makes sense).  How do I merge on multiple queries?  And should these be right joins?  Thanks for the help and information

[BiNavPete · Accepted solution]

Hi @CMSGuy 

Tricky without a sample PBIX, but my initial thought is to Append all three tables (rather than merge) then do a Group BY on EmployeeID

Pete
Web: https://binavigation.com
Linked In: https://www.linkedin.com/in/pete-smith-955b73181

[CMSGuy]

I will try that and let you know. Thanks for the information. And later, if needed, I probably can put together a sample pbx and send it