From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Unlock the full course today

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

Statistical functions

Statistical functions - Power BI Tutorial

From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Start my 1-month free trial Buy for my team

Statistical functions

“

- To calculate distributions, probability, and other statistical outcomes, we use statistical functions in DAX. Let's go to our sample data. Here, we have a matrix that has category sales, and what we want to do here is look at some basic statistical functions. Functions such as median min/max are very straightforward to work with. We simply take a range or a column of data, plug it into the function, and I've done this here for median, min and max as examples for you in the solution file. So if you click on each measure, you're able to see how we're able to derive the value that is being shown in the matrix. Very simple, very straightforward, and there are some statistical functions that operate in that way. Let's look at our second example. In this scenario, what we want to rank is our sales by product category, and know which is the most profitable category. So we can easily determine this from our data,…

Contents