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 , 

ANB_13's avatar
ANB_13
Icon for Helper I rankHelper I
3 years ago

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's avatar
    bhelou
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    Dear , 

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

    Regards , 


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

    Dear , 

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

    Thanks ,