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 - portal.enterpri...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterpri...
FREE - 60 Page DAX Reference Guide Download - enterprisedna....
FREE - Power BI Resources - enterprisedna....
Enterprise DNA Membership - enterprisedna....
Enterprise DNA Online - portal.enterpri...
Enterprise DNA Events - enterprisedna....
**** Related Links ****
Using Complex Logic Inside Iterating Functions - Advanced DAX - • Using Complex Logic In...
How To Use Iterating Functions To Solve Total Issues In Power BI - DAX Concepts - • How To Use Iterating F...
Advanced Logic Within DAX Iterating Functions - Detailed Example - blog.enterpris...
**** Related Course Modules ****
Mastering DAX Calculations - portal.enterpri...
Solving Analytical Scenarios w/Power BI & DAX - portal.enterpri...
Unique Analytical Scenarios - portal.enterpri...
**** Related Support Forum Posts ****
Combining Aggregating & Iterating Functions To Calculate Median - forum.enterpri...
Creating Plan / Actual For Year & Months - forum.enterpri...
Calculating Average And Using DateMonth - forum.enterpri...
For more iterating functions support queries to review see here….. - forum.enterpri...
Негізгі бет Iterating Functions Deep Dive - SUMX, AVERAGEX, MINX, MAXX
Пікірлер: 15