In this video, the instructor introduces and demonstrates several common math and statistics functions in DAX, such as SUM, DIVIDE, MAX, MIN, and AVERAGE.
- [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 functions.…
All right, so back in the food mart data model…
- Power Pivots versus normal pivots
- Creating calculated columns and measures
- Power Pivot and DAX best practices
- Math, stats, and COUNT functions
- CALCULATE, FILTER, and ALL functions
- Joining data with RELATED
- Using iterator functions (SUMX and RANKX)
- Time intelligence formulas
Skill Level Intermediate
1. Getting Started
Set expectations1m 46s
2. Power Pivot and DAX 101
3. Common DAX Functions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.