Adding values of two columns in two tables

[ShradhaJain]

Hi, 

I have two tables with SQL Server as source in my Power BI Report 

Name	Date	Calc1
ABC	31st Dec,2018	50
ABC	31st Dec,2019	90
ABC	31st Dec,2020	10
ABC	31st Dec,2021	40

Name	Date	Calc2
PQR	31st Dec,2018	100
PQR	31st Dec,2019	110
PQR	31st Dec,2020	200
PQR	31st Dec,2021	340

I want a new column which is = Calc1 +Calc2 . How can I do it ?

[v-chuncz-msft · Accepted solution]

@ShradhaJain ,

You may try Merge Queries (Table.NestedJoin) and Append Queries (Table.Combine) in Query Editor.

[Anonymous]

---

@ShradhaJain wrote:

Hi, 

I have two tables with SQL Server as source in my Power BI Report 

Name	Date	Calc1
ABC	31st Dec,2018	50
ABC	31st Dec,2019	90
ABC	31st Dec,2020	10
ABC	31st Dec,2021	40

Name	Date	Calc2
PQR	31st Dec,2018	100
PQR	31st Dec,2019	110
PQR	31st Dec,2020	200
PQR	31st Dec,2021	340

I want a new column which is = Calc1 +Calc2 . How can I do it ?

---

---

@ShradhaJain wrote:

Hi, 

I have two tables with SQL Server as source in my Power BI Report 

Name	Date	Calc1
ABC	31st Dec,2018	50
ABC	31st Dec,2019	90
ABC	31st Dec,2020	10
ABC	31st Dec,2021	40

Name	Date	Calc2
PQR	31st Dec,2018	100
PQR	31st Dec,2019	110
PQR	31st Dec,2020	200
PQR	31st Dec,2021	340

I want a new column which is = Calc1 +Calc2 . How can I do it ?

---

---

@ShradhaJain wrote:

Hi, 

I have two tables with SQL Server as source in my Power BI Report 

Name	Date	Calc1
ABC	31st Dec,2018	50
ABC	31st Dec,2019	90
ABC	31st Dec,2020	10
ABC	31st Dec,2021	40

Name	Date	Calc2
PQR	31st Dec,2018	100
PQR	31st Dec,2019	110
PQR	31st Dec,2020	200
PQR	31st Dec,2021	340

I want a new column which is = Calc1 +Calc2 . How can I do it ?

---

Hi,

You can summarize with a calculate function:

Sum Calc = CALCULATE (SUM (Table1 [Calc1]) + SUM (Table2 [Calc2]))

But first you must link both tables in the data model:

This is how it looks: