Forum Discussion
New column
Hi,
I'm creating a new column by adding values of five other columns together, but where there are null values, the new column also returns a numm value - can you suggest how I can fix this please?
Thanks
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.
3 Replies
Hi GMonk55
Could you share a screenshot of the used fomula in your 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.
