Forum Discussion
How to do a LEFT Outer join ?
Hi,
I have a Employee table and a Training_sessions table.
My customer would like to have number of training by Employee including people who don't make any training
In addition, thew would like the percentage of people who don't make any training.
Any help is very welcome !
Thanks
Jerome
Hi Anonymous ,
If you want a visual, you could follow the steps of amitchandak. If you want a table, you could use merge queries feature in Query Editor.
Best Regards,
Jay
4 Replies
- amitchandak
Super User
Anonymous , +0 to measure or use this option
Hi Anonymous ,
If you want a visual, you could follow the steps of amitchandak. If you want a table, you could use merge queries feature in Query Editor.
Best Regards,
Jay
MintuBaruahHelper III
Hi Anonymous
I found this link very useful. Hope this will help you with resolving your solution.
Link: https://docs.microsoft.com/en-us/power-query/merge-queries-left-outer
Regards,
Mintu Baruah
If you find the solution useful please mark my post as a solution!
In doing so, you are also helping me. Thank you!https://docs.microsoft.com/en-us/power-query/merge-queries-left-outer
Please refer this link
