Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise