Append queries
Before you finalize your transformations, there are currently two sales tables, one for the USA and one for International sales.
In this exercise, you'll combine both sales tables to create a single table that can be used to analyze sales of all countries.
We do not recommend doing so, but if you lost progress you can load the solution workbook of the previous exercise 1_2_transforming_data.pbix
from the Exercises folder.
This exercise is part of the course
Case Study: Competitor Sales Analysis in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
