Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @Jerome83 ,
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
https://docs.microsoft.com/en-us/power-query/merge-queries-left-outer
Please refer this link
Hi @Jerome83
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!
Hi @Jerome83 ,
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
@Jerome83 , +0 to measure or use this option
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |