Page 297 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

The list of items shown is based on a sample of the data so may not contain all available items in the data. You
can load more by clicking on the Load more text in blue.

Many transformations found in the ribbon menu are also accessible from the data preview area using a right click
on the column heading. Some of the action you select from this right click menu will replace the current column. If
you want to create a new column based, use a command from the Add Column tab instead.
The Applied Steps
Any transformation you make to your data will appear as a step in the Applied Steps area. It also allows you to
navigate through your query. Left click on any step and the data preview will update to show all transformations
up to and including that step.

You can insert new steps into the query at any point by selecting the previous step and then creating the
transformation in the data preview. Power Query will then ask if you want to insert this new step. Careful though,
as this may break the following steps that refer to something you changed.

284

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