Forum Discussion
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.
Community SupportHi, 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.