Get to know Power Query

Review the applied steps

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Before finishing, let’s walk through each query step of the Product Sales query and make any adjustments. Because you finished the last step on the new query that merged the Product and Category tables, expand the Queries pane and select the Product Sales table. This is the step in the Product Sales table in which you added the Bonus column.

This is just a sample of what you can do, but it's always a good idea to go through your applied steps before you distribute your workbook. You might find that certain steps can be managed better, once you get an entire transformation set up. It's also better to catch an issue up front than to have someone point it out later.

  1. To return table data to its original state, select Source step, and do the following:

    Steps

    Comments and actions

    Source and Changed Type

    These are automatically added. You could delete the Changed Type step because you adjust the Date Type in a following step.

    Renamed Columns

    Added when you renamed columns from their original database names.

    Note   As you select each step, Power Query previews it for you.

    Changed Type1

    Added when you changed the date to not include hours or minutes. For clarity, change it to Changed Date Type.

    Split Column by Delimit

    For clarity, change it to Split Sales Rep Names.

    Added Custom

    For clarity, change to Bonus.

    Tip   You can also change a step's parameters by clicking on the gear icon if it has one. For example, you might change the sales amount or commission percentage.

  2. To return the transformed data to an Excel worksheet, Select Home > Close & Load.         

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.