List.Average is not computed correctly in this code. [ Source = #table({"Value"}, {{null}, {1}}) & #table({"Value"}, {{2}}), Avg = List.Average(Source[Value]) ] It computes to 1 wh...
The steps to reproduce are simply to start with a blank query and paste in the example code shown above in the Advanced Editor. I see the error with this demonstration code and in another full-blown query where I first saw the issue. I've tested it on the latest versions of Excel and Power BI. The erroneous behavior is the same. I also see this issue acknowledged on the Power Apps platform forum.
List.Average not computed correctly on the list of... - Power Platform Community (microsoft.com)