NEW! FREE 1 Hour Excel Data Cleaning Course! Watch now 

Power BITutorials

Delete Steps Until End By Power Query

1 Mins read
DELETE STEPS UNTIL END

If you want to delete some steps, you can do it in one shot. The Power Query Delete Until End feature helps to delete as many steps up to the end in one click.

Delete Steps Until End By Power Query

Let us understand this feature with the help of an example.

Step 1: Load the data and add Index Column

As discussed in the above topic, add an index column and rearrange the order of it. Also, change the header type as shown in below pictureAFTER MODIFYING DATA Table

Step 2: Delete Steps until End

After you modify the data and you realize that some steps are added extra that should not have been added, then you can delete them in one shot as given below.

Right-click on Added Index  >  Delete until End

DELETE STEPS UNTIL END

 

Step 3: Delete Steps

When you click on Delete Until End option, a dialogue box appears on the screen that allows to click on the Delete option and delete all these steps.

DELETE STEPS

This will remove all the steps performed after the Added Index step. Now your Applied Steps area will look like this.

AFTER DELETING STEPS

Step 4: Close and Apply

After deleting these steps, data table will come back to its original form as shown in the below picture. Just click on Close & Apply button after you finish your task.

DATA TABLE AFTER DELETING STEPS UNTIL END

You can learn more :

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…