Part V: Understanding Power Pivot and Power Query
This function tells Power Query to evaluate the [2016 Potential Revenue] field for
each record. If the potential revenue is greater than or equal to 10,000, use the word
LARGE; if not, use the word SMALL.
Figure 39.29 demonstrates this if statement as it is applied in the Add Custom Column dia-
log box.
FIGURE 39.29
Applying an if statement in a custom column
Power Query pays no attention to white space. This means you can put as many spaces and carriage returns as you’d
like. As long as the correct case and spelling is used, Power Query will not complain. Figure 39.29 illustrates how
separating formulas into multiple lines can make them much easier to read.
Grouping and Aggregating Data
In some cases, you may need to transform your data set into compact groups to get it into a
manageable size of unique values. You may even need to summarize numerical values into
an aggregate view. An aggregate view is a grouped snapshot of your data that will show
sums, averages, counts, and more.
