cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jerome83
New Member

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

 

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

4 REPLIES 4
bhagyashrinik96
Regular Visitor

MintuBaruah
Helper I
Helper I

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
Community Support
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

amitchandak
Super User IV
Super User IV

@Jerome83 , +0 to measure or use this option

ShowItemwithoutdata.JPG



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors