Page 300 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

When you click on different steps of the transformation process in the Applied Steps area, the formula bar updates
to show the M code that was created for that step. If the M code generated is longer than the formula bar, you can
expand the formula bar using the arrow toggle on the right hand side.

You can edit the M code for a step directly from the
formula bar without the need to open the advanced
editor. In this example, we’ve changed our filter
from “Pen” to “Chair” by typing in the formula bar
and then pressing Enter or using the check mark
on the left to confirm the change. Press Esc or use
the X on the left to discard any changes.
The File Tab

The File tab contains various options for saving
any changes made to your queries as well as
power query options and settings.

• Close & Load – This will save your queries
and load your current query into an Excel table
in the workbook.
• Close & Load To – This will open the Import
Data menu with various data loading options to
choose from.
• Discard & Close – This will discard any
changes you made to the queries during your
session in the editor and close the editor.
Data Loading Options

When you use the Close & Load To option to exit the editor, this will open the Import Data menu.
You can choose to load the query to a table, pivot table, pivot chart or only create a connection for the query. The
connection only option will mean there is no data output to the workbook, but you can still use this query in other
queries. This is a good option if the query is an intermediate step in a data transformation process.
You’ll also be able to select the location to load to in your workbook if you selected either a table, pivot table or
pivot chart in the previous section. You can choose a cell in an existing worksheet or load it to a new sheet that
Excel will create for you automatically.

287

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