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.
Data Analytics Tricks in Power BI – Guidebook
You too can analyze data like a Data Scientist. No coding needed. No statistics needed.
Analyze & Visualize data using Power BI. (23 tricks in one book)
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.
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.
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.
In this way, the Added Conditional Column step gets separated from the other steps into a new query.
Data Analytics Tricks in Power BI – Guidebook
You too can analyze data like a Data Scientist. No coding needed. No statistics needed.
Analyze & Visualize data using Power BI. (23 tricks in one book)