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. 💡