Forum Discussion
PowerQuery: Sum Calculated Columns
Hi, all. I have cleaned some data in power query and from the 10 original data columns, I created 10 more calculated columns (converting some raw fertilizer columns into converted nitrate columns). ...
slohombre Do you have "null" in the individual calculated column(s)? If so, it may cause your sum to be null.
I think you could either fix the "null" in each individual column first by wrapping them with if ... is null then 0, then in your sum column simply add them, or try to revise your formula bar from Table.AddColumn(..., each [calculated column A] + [calculated column B]...) to Table.AddColumn(..., each
List.Sum({[A], [B]}) ...)