Merging queries: right join
Your manager is interested in evaluating salespeople that have had more than one order per customer in a particular region. To assist with this process, a table of orders per region was assembled so you can combine with your existing sales data. A right join is perfect for this situation as it allows you to only join the relevant data for your analysis.
If you lost any progress, load the workbook 2_3_right_join.pbix
from the Exercises folder on the Desktop.
This exercise is part of the course
Data Transformation in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
