Iterators

Iterators (SUMX, AVERAGEX, MAXX...) go through a table row by row, evaluate an expression for each row, then aggregate the results. They make it possible to compute from several columns of the same row, which simple single-column aggregations cannot do.

Example

CA = SUMX(Ventes, Ventes[Quantité] * Ventes[Prix])

Related concepts

The whole glossary