Group By

Group By summarizes rows into one row per group, with an aggregation (sum, average, count, minimum, maximum). It reduces volume and sets the granularity of a table, like a GROUP BY in SQL.

Table.Group(Source, {"Région"}, {{"Total", each List.Sum([Montant]), type number}})

The whole glossary