New column

[GMonk55]

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

[GMonk55 · Accepted solution]

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

[v-yalanwu-msft · Accepted solution]

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.

[GMonk55 · Accepted solution]

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

[DataVitalizer]

Hi @GMonk55 

Could you share a screenshot of the used fomula in your column?