Solved: Sum multiple Columns formula - Microsoft Power BI ...
community.powerbi.com › t5 › Power-QueryNov 15, 2021 · I would like to sum mutliple columns in a table. For now, I simply did it like this: As the amount of columns might vary from time to time, I aim to make it more flexible. In all columns that have to be summed the word "Capacity" will always appear in the first row. Is it possible to create a Column based on a formula in the Power Query Editor which automatically sums all Columns which have the word capacity in its first row?
Correctly Sum Two Or More Columns in Power Query and Power BI
excel-inside.pro › blog › 2019/01/16Jan 16, 2019 · Sum of columns in Power Query is easy as 1-2-3. For example, we want to sum columns [A] and [C]. Just click (holding Ctrl button) column headers you want to sum, then go to “Add Column” – “Standard” – “Add”, and you’ll get a new column named “Addition” with the row-by-row sum of desired columns: Sum of columns [A] and [C] – sure it is. If we want to add three columns at a time, then we’ll also get a desired result: