New column

Thank you for your reply. I've managed to make it work by replacing all the numms with zeros.

Hi, GMonk55 ;

Null values indicate an empty cell or the absence of any data.

And in that sense, you can’t really call null a value. While zero is an actual value, null is the absence of a value.

You could replace null values by 0, use error checking or make use of the List.Sum formula.here i tested the List.Sum formula.

The final show:

3 Ways to SUM null values in Power Query M - BI Gorilla
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.