Forum Discussion
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...
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.
Hi AhmadJamil ,
Did Ashish_Mathur reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.
Best Regards,
Adamk Kong