This is the last chapter in which we will be looking at the different groups of DAX functions. In this chapter, we will be looking at the group of functions that help us to perform statistical aggregations.
As in previous chapters, we will start this chapter with a complete list of the functions found in this group, along with a brief description of each. We'll then move on and look in more detail at some of the more commonly used functions in this group, all while using hands-on examples to explain how they work.
The chapter is broken into the following sections:
- Introducing statistical functions
- Calculating averages
- Working with percentiles
- Ranking your data
- Calculating standard deviation and variance
