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). ...
Bit more to above. Simplest way is to use Add as Riny_van_Eekelen suggested. However, if you add only two columns, in generated formula it will be like each [Column1] + [Column2]
And, as hynguyen explained, any number plus null returns null.
However, if click Add on more than two columns, List.Sum() will be generated automatically, which doesn't care about nulls.
Thus result is number of columns specific.
SergeiBaklan Thank you!
slohombre , you are welcome
