How to do a LEFT Outer join ?

[Jerome83]

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

[Anonymous]

https://docs.microsoft.com/en-us/power-query/merge-queries-left-outer

Please refer this link

[MintuBaruah]

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!

[v-jayw-msft · Accepted 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.

https://blog.enterprisedna.co/how-to-merge-queries-in-power-bi/#:~:text=Merge%20Queries%20Option%20I... 

Best Regards,

Jay

[amitchandak]

@Jerome83 , +0 to measure or use this option