List.Average is a Power Query M function that calculates the average value for items in a list. The function returns the average value in the same datatype as the list’s values, working with number, date, time, datetime, datetimezone, and duration values.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
List.Average( list as list, optional precision as nullable number, ) as any
|precision||optional||The Precision.Type specifies the accuracy level for calculations. When omitting this argument, Power Query uses Precision.Double by default, which, while efficient, may cause rounding errors with very small fractions. For greater accuracy Precision.Decimal offers a more precise number representation, ideal for tasks requiring high precision.|