Aggregate Functions In Microsoft Power Apps –

Syntax is FunctionName(Collection Or DataSource Or Table, ColumnName)

Average function – Calculates the average, or arithmetic mean

Max function -finds the maximum value.

Min function -finds the minimum value.

Sum function -calculates the sum of its arguments.

StdevP -function calculates the standard deviation of its arguments.

VarP -function calculates the variance of its arguments.

We have one Data source Table or collection as mentioned below. Its name is “ProductSalesValue”

ProductName	SalesValue
Bush Somerset Collection Bookcase	261.96
Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back	731.94
Self-Adhesive Address Labels for Typewriters by Universal	14.62
Bretford CR4500 Series Slim Rectangular Table	957.5775
Eldon Fold ‘N Roll Cart System	22.368
Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood	48.86
Newell 322	7.28
Mitel 5320 IP Phone VoIP phone	907.152
DXL Angle-View Binders with Locking Rings by Samsill	18.504
Belkin F5C206VTEL 6 Outlet Surge	114.9
Chromcraft Rectangular Conference Tables	1706.184
Konftel 250 Conference phone – Charcoal black	911.424
Xerox 1967	15.552
Fellowes PB200 Plastic Comb Binding Machine	407.976

Average function = Average(ProductSalesValue, SalesValue)

Max function = Max (ProductSalesValue, SalesValue)

Min function = Min (ProductSalesValue, SalesValue)

Sum function = Sum (ProductSalesValue, SalesValue)

StdevP = StdevP(ProductSalesValue, SalesValue)

VarP  = VarP (ProductSalesValue, SalesValue)

To learn more about please read link – https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-aggregates?WT.mc_id=DX-MVP-5003911