In this video, the instructor introduces you to iterator, or "X" functions, which operate by repeating a calculation across all rows in a table and aggregating the results. In this demo, look at the SUMX function specifically.
- [Instructor] All right, we're savin' some of…the best stuff for last,…'cause up now, we've got iterator, or X functions.…And the thing about these iterator functions…is that they allow you to loop through…the same calculation or expression…on every single row of a table…and then apply some sort of aggregation…to the results.…So you can take the sum, the max, the min,…the count, the average, any kind of aggregation.…So if you've ever written a sum product function…in Excel, then you already know how these work.…Because the sum product takes a product…on each row of the data set…and then sums the answers up.…
The difference is that instead of just…taking a sum, like a sumx,…you've got several other options as well.…So you've got a countx version, an averagex,…a rankx, a maxx and a minx.…And each of these applies a different…type of aggregation to the results derived…by the expression.…So the first argument in the syntax…is just a reference to the table.…And this is the table in which…the expression will be evaluated.…
Author
Released
5/9/2018- 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
Duration
Views
Related Courses
-
Excel 2016 Essential Training
with Dennis Taylor8h 53m Beginner -
Excel Tips Weekly
with Dennis Taylor28h 47m Intermediate -
Excel 2013: Data Validation
with Dennis Taylor1h 5m Intermediate
-
Introduction
-
Welcome56s
-
-
1. Getting Started
-
Set expectations1m 46s
-
2. Power Pivot and DAX 101
-
Create a Power Pivot table5m 27s
-
Calculated columns8m 39s
-
DAX measures2m 24s
-
Create implicit measures1m 59s
-
Understand filter context9m 18s
-
Power Pivot best practices1m 48s
-
3. Common DAX Functions
-
Basic math and stats functions12m 45s
-
Switch and Switch (TRUE)10m 33s
-
Text functions10m 53s
-
The CALCULATE function14m 39s
-
Join data with RELATED3m 39s
-
Iterator ("X") functions: SUMX12m 20s
-
Time intelligence formulas17m 2s
-
DAX best practices2m 3s
-
Conclusion
-
Final section53s
-
Data visualization options4m 24s
-
Conclusion24s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Iterator ("X") functions: SUMX