Page 298 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

You can delete any steps that were applied using the X on the left hand side of the step name in the Applied Steps
area. Caution is needed though, as if any of the following steps depend on the step you’re trying delete, you will
break your query. This is where Delete Until End from the right click menu can be handy.

A lot of transformation steps available in power query will have various user input parameters and other setting
associated with them. If you apply a filter on the product column to show all items not starting with Pen, you might
later decide you need to change this filter step to show all items not equal to Pen. You can make these edits from
the Applied Step area.

285

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77