List.Average

This function computes the average value of the elements in the list named "list". The output will be in the same data type as the values in the list. This function only accepts number, date, time, datetime, datetimezone, and duration values. If the list is empty, the function will return null.

Calculate the mean value of a given set of numbers or dates by using the MList.Average function in Power Query. For example, to find the average of the numbers 3, 4, and 6, use the syntax MList.Average({3, 4, 6}), which will return an output of 4.333333333333333. Similarly, to determine the average date value between January 1, 2011, January 2, 2011, and January 3, 2011, use the function MList.Average({#date(2011, 1, 1), #date(2011, 1, 2), #date(2011, 1, 3)}), which will output #date(2011, 1, 2).