Part V: Understanding Power Pivot and Power Query
FIGURE 38.7
You can click the Table Actions icon to select actions (such as Remove Errors) that
you want applied to the entire data table.
- Once all the errors are removed, add a Week Of field that displays the week to
which each date in the table belongs. To do this, right-click the Date field and
select the Duplicate Column option. A new column (named Date -Copy) is added to
the preview.
- Right-click the newly added column, select the Rename option, and then
rename the column Week Of.
- Right-click the Week Of column you just created and select the Transform ➪
Week ➪ Start of Week, as shown in Figure 38.8. Excel transforms the date to dis-
play the start of the week for a given date.
FIGURE 38.8
The Power Query Editor can be used to apply transformation actions such as display-
ing the start of the week for a given date.
