Create a Column where sum two columns from different tables

[Beto_Zambom]

Hi guys, not sure if this is possible:

In Table 1 I have a column called Amount Table1[Amount]

In table 2 I have a clumn called Extra Table2[Extra]

What I want to do is on Table 1 sum those two values in a new column:

New Column = Table1[amount]+ Table2[Extra]

[ANB_13]

Hello, 

I have the same problem but in my case i would to do division "/" calcul. I have two tables that i create relations (Months-Months) and i would like to create a new column that i do this calculation : column A from table A / column B from table B.

Thank you very much in advance 

[bhelou]

Dear , 

Check if you have a unique table , you can use related or lookupvalue with the devide measure . 

Thanks , 

[bhelou]

Dear , 

Can you share some data  to help you with solving it . 

Regards , 

[bhelou · Accepted solution]

Hello , 

first to make this work you should make a relationship between the tables  and you should have a unique identifier , you have 3 options : 

1- merge the 2 tables in power queries 
2- make a new table in power bi as a summarize 
3 - measure in a column in table 1 : Total = Table1[Amount] + RELATED(Table2[Extra]) 

measure 3 will work if you have realationship correct . 

Kindly accept as a solution if it works with you and a kudo would be greatfull . 

Regards , 

[Beto_Zambom]

Thanks work fine. The problem was the relationship between the tables.