Add column of sum

[Reimer]

Hi all,

It seems pretty basic, but I cant seem to figure it our. I have a table sorted by month with the salary costs and a column per office (so Column A is month, Column B New York, Column C Washington. No I want to add a column D for the total salary Costs. Each Column is uploaded in a different dataset.  Any easy way to do this?

[v-lionel-msft · Accepted solution]

Hi @Reimer ,

Like this?

Measure = MAX(Sheet1[New York]) + MAX(Sheet1[Washington])

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Reimer , You can sum that up and analyze across common dimension

Total Salary = Sum(Table1[ColumnA])+Sum(Table2[ColumnB])+Sum(Table3[ColumnC])+Sum(Table4[Columnd])

Or merge the data sources

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Tahreem24]

@Reimer ,

TRy adding the all columns like below:

Total Salary Measure = Sum(Table[ColumnA])+Sum(Table[ColumnB])+Sum(Table[ColumnC])