In Power BI you must understand the difference between aggregating functions and iterating functions very well.

In this tutorial we'll be diving into iterating functions including SUMX, AVERAGEX, MINX & MAXX. Well be seeing the various ways they can be used and also going into detail how results are actually calculated when using these formulas.

These are some crucial concepts in Power BI when using DAX, so certainly dive into this content in detail and start practicing when you can using these techniques.

***** Video Details *****
1:32 - iterating using SUMX
3:08 - using an alternative approach to SUMX
7:00 - iterating through tables
8:58 - iterating using MINX
9:46 - iterating using MAXX

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - [ Ссылка ]
FREE COURSE - Ultimate Beginners Guide To DAX - [ Ссылка ]
FREE - 60 Page DAX Reference Guide Download - [ Ссылка ]
FREE - Power BI Resources - [ Ссылка ]
Enterprise DNA Membership - [ Ссылка ]
Enterprise DNA Online - [ Ссылка ]
Enterprise DNA Events - [ Ссылка ]

***** Related Links *****
Using Complex Logic Inside Iterating Functions – Advanced DAX - [ Ссылка ]
How To Use Iterating Functions To Solve Total Issues In Power BI – DAX Concepts - [ Ссылка ]
Advanced Logic Within DAX Iterating Functions – Detailed Example - [ Ссылка ]

***** Related Course Modules *****
Mastering DAX Calculations - [ Ссылка ]
Solving Analytical Scenarios w/Power BI & DAX - [ Ссылка ]
Unique Analytical Scenarios - [ Ссылка ]

***** Related Support Forum Posts *****
Combining Aggregating & Iterating Functions To Calculate Median - [ Ссылка ]
Creating Plan / Actual For Year & Months - [ Ссылка ]
Calculating Average And Using DateMonth - [ Ссылка ]
For more iterating functions support queries to review see here….. - [ Ссылка ]

свернуть