O'Reilly logo

The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI by Marco Russo, Alberto Ferrari

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8. Statistical functions

DAX provides a number of statistical functions that simplify the code you write to perform the corresponding calculations. New DAX versions introduced a few statistical functions not present in previous versions, so you will find corresponding workarounds and patterns in case the DAX version you use does not support the function you need.

In this chapter, you will learn how to obtain the ranking value of an element, how to calculate variances, standard deviations, and percentiles. You will also learn functions for calculating interest, computing the geometric mean, and obtaining a sample from a table.

Using RANKX

If you want to show the ranking value of an element according to a specific sort order, you can use ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required