How do I create a column that sums from the same row

[semidevil]

Maybe I'm missing something, but I want to create a column that sums 2 cells in the same row.  Something very similar to excel where column C1 = A1 + B1, C2 = A2 + B2, etc etc

I used SUMX but the new column is populated with the same number for the entire column (appears to be the grand total of all rows and columns combined)

Net = SUMX(Table1, Col1[cost] + Col2[gain])

[RobertSlattery · Accepted solution]

Hi, are you putting this column into a calculated column or a measure?

If you are putting it in a measure, you will get the total of the sum of the two columns in the row context which depends on the granularity of your visual. So

    Net := SUMX(Table1, Col1[cost] + Col2[gain])

Will work.

If you are putting it into a calculated column then just write 

    Net = Col1[cost] + Col2[gain]

(The convention is "measure := ..." or "calculated column = ...")