In order to proceed with our query merging, we need to create a unique ID column. We can do this by merging columns together, which we will see in this lesson.

If your data includes more rows than you actually need, you can use the Query Editor's extensive filtering capabilities to see only the data you need to use. We'll see the different types of filter in this lesson.

In this lesson, we will look at a variety of smaller tasks you might do with columns, including splitting columns, replacing values and removing columns.

You can add columns to your dataset in the Query Editor. In this lesson, we will see how you can add columns using a formula or using IF/ELSE conditions.

Underlying all the actions we take in the Query Editor is a formula language called M. In this lesson, we will look at the M code behind our query and discuss when using M is a good or bad idea.

You will generally want to make changes to your query at a later time. We'll discuss how to edit queries safely, and load the query output into Power BI Desktop, in this lesson.

One of the key strengths of the Query Editor is that new data can often be added with little, if any, modifications to the query. In this lesson, we'll see how to add more data and refresh the query.