From the course: Excel Business Intelligence: Power Query

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Number-specific query editing tools

Number-specific query editing tools - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Query

Start my 1-month free trial

Number-specific query editing tools

“

- [Instructor] Okay, moving right along to the number specific tools, taking a look at the Transform tab in the Query Editor. Towards the end there you'll see this grouping of tools. These are our number tools. And we've got some interesting options in here. First, we've got Statics options. And these are aggregation style functions, like sum, minimum, maximum, average, count values, count distinct. And what's interesting about these is they evaluate these functions for an entire selected column and return a single value. So, you can't use them to create a new column and you don't evaluate on a row-by-row basis. So, as you can probably guess, this isn't really helpful when it comes to shaping or transforming data or prepping it for loading. But it is helpful to explore and better understand the data that you're working with. Next up, we've got Standard Options. So these are other statistical operations and calculations. You've got the basic standard ones, like addition…

Contents