journalbad.blogg.se

Select the TopCustomers query and click on the step called Calculated End of Month.

Let’s take a look at that in this section. The applied steps box is also used to insert, move and delete steps. Woop, Woop! We have just edited the query. The query is currently set to show 5 customers, change this to 3, and click OK. Using the Example file, select the Top Customers query, then click on the gear icon next to the Keep First Rows step. Clicking the icon reveals the options window for that specific step. The gear icon exists next to many of the steps within the applied steps list. Use one of the methods above for opening Power Query, then we can get started editing transformations. We will to modify the existing from that file transformations. For the remainder of this post, we are working with the example file.

Now that we’ve selected a query, we are ready to start editing. Once the queries pane is open, click on any individual query to activate it for viewing or editing.

If the queries pane on the left is closed, click on the > arrow to expand the list. Once the Power Query editor opens, we can edit any query in the workbook. Then, Click Query > Edit.Īlso, right-clicking on a Table and selecting Table > Edit Query can get to the query editor. Click Data > Get Data > Launch Power Query Editor….Ĭlicking on a Table containing a query (green striped format by default) will reveal the Query ribbon. We can get directly into the Power Query editor from the ribbon we don’t need to select any specific query. Click the Edit option at the bottom.Īll 3 of these options will get you into the Power Query editor.

I will briefly cover the most common below, though we only need to know one or two. Opening the Power Query editor to edit an existing query is no different there are loads of ways to do it. As with many features of Power Query, there are multiple ways to access the same action.