Column Average
Syntax:
average(Table.Column)
avg(Table.Column)
Calculate the average of a column. You can also use alternative syntaxes for improved readability: avg() and mean().
Examples
Column Average that Meet a Condition
Syntax:
averageif(Table.Column, Table Column Condition)
avgif(Table.Column, Table Column Condition)
Calculate average of a column of numbers that meet your specified condition. You can also use alternative syntaxes for improved readability: avgif() and meanif().