Counting nulls

Hi Dicken,

For pure null values, I would keep your first approach. It is probably the cleanest and easiest to read:

let
    alist = {1,2,2,"a",null, null, 2,"a",3,2,null, "a"}
in
    List.Count(alist) - List.NonNullCount(alist)

List.NonNullCount is built to count non-null items, so total count minus non-null count gives the null count.

List.Accumulate(alist, 0, (i,x) => i + Number.From(x=null))

List.Sum(List.Transform( alist, each Number.From(_=null)))