From the course: Excel Business Intelligence: Power Pivot and DAX

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

Basic math and stats functions

Basic math and stats functions - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot and DAX

Start my 1-month free trial Buy for my team

Basic math and stats functions

“

- [Instructor] All right, so let's kick things off with some basic math and stats. Now these should look very familiar. We're gonna start easy, start with the ones that are very comparable to traditional Excel functions and then eventually progress into the more complex stuff and into the more DAX specific stuff towards the end of the section. So kicking off sum obviously evaluates the sum of a column. There is your syntax. Average returns the arithmetic mean, straight forward. Max returns the largest value. There are two ways to use a max formula with DAX. You can feed it a column or you can feed it individual expressions and it will return the max out of that list. The same goes with min and then divide is just a variation of using an actual divide operator. Both work fine, the divide function itself just gives you that third optional component, which is like your value if error. So with that let's jump into Excel and start creating some measure using these basic math and stats…

Contents