NEW! FREE 30 Minutes MS Excel - Working with Dates Course  Watch now 

Power BITutorials

Learn How to Split Queries In Power Query

1 Mins read

As explained in the above example, we have generated a conditional column for the given query. If we want to split this query into two, Power Query will help us in doing so. To get more in-depth knowledge about Power Query, then check our latest Power Query Course that provides high-class videos with life time access.

How to Split Queries In Power Query

The user will be able to mark a set of consequent steps, starting at the first one, and split the query so the marked steps become a new query and the rest become a query referencing the first one as a source. This is useful if the first steps of a query are actually required for a few other queries.

 

Step 1: Click on Extract Previous option

To split the queries, right-click on the Applied Step that you want to split from the query as shown below.

EXTRACT PREVIOUS TO SPLIT QUERIES

Step 2: Specify New Query Name

Specify the new Query name in the ‘New Query name’ option of the Extract Steps window as shown below.

 EXTRACTING PREVIOUS INTO A NEW QUERY

 

Step 3: RENAME THE QUERIES

When you click on OK, the Power query will split the queries into two. You can rename queries if you want. The picture below shows the final data.

After Splitting Queries

In this way, the Added Conditional Column step gets separated from the other steps into a new query.

After Splitting Queries

You can acquire knowledge more : 

  • Study How to Navigate Query Editor Using Power Query
  • Read How to Disable Relationship Detection in Excel
  • Steps to Editing A Query in Excel 
  • Learn How to Create Grouped Serial Numbers In Power Query
Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…