Forum Discussion

AhmadJamil's avatar
AhmadJamil
Frequent Visitor
2 years ago
Solved

Merging records from two tables

Hi, I am sure this question has been asked before and must have a solution, nevertheless, I am struggling so asking for help. I have two tables, like following, and want to merge them in a way tha...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Rename the amount column to Amount 1 in Table2.  Append both tables in the Query Editor to get 5 columns.  In your matrix visual, drag ID1, ID2 and ID3 columns.  Write these measures

    Measure = sum(Data[Amount])

    Measure1 = sum(Data[Amount1])

    Variance = [Measure]-[Measure1]

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Rename the amount column to Amount 1 in Table2.  Append both tables in the Query Editor to get 5 columns.  In your matrix visual, drag ID1, ID2 and ID3 columns.  Write these measures

Measure = sum(Data[Amount])

Measure1 = sum(Data[Amount1])

Variance = [Measure]-[Measure1]

Hope this helps.

AhmadJamil's avatar
AhmadJamil
Frequent Visitor
2 years ago

Hi Ashih, 
Thank you for your response. The technique seems working fine with the sample data, I will apply it on the actual tables and will let you know if I need more help.

Thanks
Ahmad