Updated on

List.Covariance is a Power Query M function that computes the covariance between two lists of numbers, which must have the same number of values. The function returns the calculated covariance value.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


   numberList1 as list,
   numberList2 as list,
) as nullable number


Returns the covariance between two lists, numberList1 and numberList2. numberList1 and numberList2 must contain the same number of number values.


Calculate the covariance between two lists.

// Output: 0.66666666666666607
List.Covariance( {1, 2, 3}, {1, 2, 3} )

Other functions related to List.Covariance are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: