Forum Discussion
Simple SUM of two columns not working (only null values returned)
Hi, I am having a strange problem in the query editor (in Power BI). I want to add a new column that is the SUM of two columns in the same table: It's really strange, if...
The + operator is returning a null because the [PAS] field is null ( number + null = null). This behavior is standard for all operators within PQ (+,-,/,*) and sql. You can override this behavior with List.Sum. List.Sum ignores nulls by definition.
List.Sum( { [Services Proactive], [PAS] } )
The + operator is returning a null because the [PAS] field is null ( number + null = null). This behavior is standard for all operators within PQ (+,-,/,*) and sql. You can override this behavior with List.Sum. List.Sum ignores nulls by definition.
List.Sum( { [Services Proactive], [PAS] } )
Ok, thank you very much.
Thanks!
