From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press (2024)

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Use basic statistical functions

Use basic statistical functions - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press (2024)

Start my 1-month free trial Buy for my team

Use basic statistical functions

“

- [Instructor] Okay, so in this lesson, we are going to take a look at using basic statistical functions. Alright, so DAX provides many functions for creating aggregation, such as sums, counts, and averages. Some common DAX statistical functions are the basic ones, average max, a couple different flavors of max and min, and the median function. We also have iterator versions of some of the statistical functions. So average X, max X, min x, and median X. So just keep in mind the X at the very back of those DAX formulas indicates those are iterator versions of those functions. And we also have a rank X function as well. So let's go to the Power BI desktop and take a look at these. Okay, so let's go ahead and once again, let's ground ourselves in taking a look at the line total sales here. So our internet sales unit price multiplied by the order quantity. And next, let's go over and take a look at the measure called "Average Line Total Sales". So here what we're going to do is use the…

Contents