In this video, the instructor outlines some of the most common DAX categories (Math and Stats, Logical, Text, Filter, and Date and Time), as well as example functions.
- [Instructor] All right, last thing before…we dive into the actual code.…I wanna talk about some common DAX function categories…just so that we can see everything in one place.…Now, these should look pretty familiar.…They follow the same kind of patterns…that normal Excel cell formulas do.…You've got your math and stats functions,…logical operators, text functions.…Got a whole kind of new category…called filter functions.…And then you've got date and time.…So, starting with math and stats,…these include your basic aggregation functions…plus some new ones called iterators,…or x functions.…
Now, for the common examples,…you've got sum, average, max, min,…plus some really cool variations of count,…like count rows and distinct count.…Now, iterator functions, or x functions,…are a little bit more advanced.…They're kind of like a sum product on steroids,…if you've ever written a sum product in Excel.…But we'll cover those towards the end of the section.…Logical functions,…these functions return information about values…
- 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.