![How Iterator Functions Work
Formulae:
- Regular: =[Units on Hand]*[Avg Cost]
- SUMX: =SUMX(Inventory,[Regular])
Screenshot of a output table with columns containing the totals generated for both formulae:
- Regular = 491.00
= SUM(1,2,4,4,9)
* AVERAGE(23.95,24.95,23.95,24.95,24.95)
- SUMX = 494.00
= SUMX(
SUM(1) * AVERAGE(23.95)
+ SUM(2) * AVERAGE(24.95)
+ SUM(4) * AVERAGE(23.95)
+ SUM(4) * AVERAGE(24.95)
+ SUM(9) * AVERAGE(24.95)
)](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:xpiehblln2cworixrwklvoyv/bafkreigxnrdqhrmkkfhkfprsv6n65uv7tvyd3xgavshtnheywyqu3ohsda)
How Iterator Functions Work Formulae: - Regular: =[Units on Hand]*[Avg Cost] - SUMX: =SUMX(Inventory,[Regular]) Screenshot of a output table with columns containing the totals generated for both formulae: - Regular = 491.00 = SUM(1,2,4,4,9) * AVERAGE(23.95,24.95,23.95,24.95,24.95) - SUMX = 494.00 = SUMX( SUM(1) * AVERAGE(23.95) + SUM(2) * AVERAGE(24.95) + SUM(4) * AVERAGE(23.95) + SUM(4) * AVERAGE(24.95) + SUM(9) * AVERAGE(24.95) )
I wrapped up the week by leading a course for CPABC on using #DAX in #PowerPivot for gaining enhanced #DataInsights.
For Example, if you've ever had to generate cost by line on a financial statement, use an Iterator function as they add a “Row Context” that Aggregator functions don’t have. 💡
