Forum Discussion

Beto_Zambom's avatar
Beto_Zambom
Frequent Visitor
3 years ago
Solved

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 ...
Need Help
Show and Tell
  • bhelou's avatar
    bhelou
    3 years ago

    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 , 

bhelou's avatar
bhelou
Icon for Responsive Resident rankResponsive Resident
3 years ago

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's avatar
    Beto_Zambom
    Frequent Visitor
    3 years ago

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