Calculated column with the sum of values from many columns in a row

Question

How to create calculated column with the sum of values from many columns in a row?

Answer 1

Hi,

You can create a new column by clicking on new column under modelling tab in power bi.

Then Enter the code as 

• Column name = Table_name[column_name 1] + Table_name[column_name 2] + Table_name[column_name 3].

Then a new column will be created from the sum of multiple columns.

Hope this helps you.

Comments

Hi,

Could you help provide a solution where the table may have more or less columns than the previous month, with different headers. Column A, B, C are always the same. Col C = TOTAL (value only - not formula).

Col D, E, F etc, contain values

I need to add a column which calculates the difference between TOTAL and the sum of other columns.

Since the table headers and number of columns will change each month it needs to be dynamic.

Any help appreciated.

Thanks

Rick

---

Hi, @Frostyr,

You can follow this regarding your query:

https://www.edureka.co/community/71307/last-10-days-data-based-on-date-time