Chapter 39: Transforming Data with Power Query
39
Creating Custom Columns
When transforming your data, you’ll sometimes have to add your own columns to extract
key data points, create new dimensions, or even create your own calculations.
You start a new custom column by going to the Add Column tab and clicking the Custom
Column command (see Figure 39.24). This activates the Custom Column dialog box.
FIGURE 39.24
Adding a custom column
The Custom Column dialog box (shown in Figure 39.25) is your workbench for adding your
own functionality to your query through the use of Power Query formulas. When you add
a new custom column, it won’t do anything until you provide a formula that gives it some
utility.
FIGURE 39.25
The Custom Column dialog box