Forum Discussion
Create a Column where sum two columns from different tables
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]
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 ,
5 Replies
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 ,Thanks work fine. The problem was the relationship between the tables.
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
