Balance Data by Comparing two table

[Chirag Chheda]

Unable to fetch balance data by comparing two tables with unique detail

Table A

A	1014	200
A	1518	100
A	1014	300
A	1014	100

Table B

A	1014	700
A	1518	100
A	1518	300

Require Output (B-A)

A	1014	100
A	1518	300

 

[PCI]

What is you data layout ??
Please attach an Excel sample file

 

[AlanSidman]

Using Power Query, you can merge the two files. Here is the Mcode for that. You will need to upload each table to PQ and then close and load to a connection only.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", Int64.Type}, {"Column3", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each [Column3] * -1),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Column3"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Custom", "Column3"}}),
    #"Appended Query" = Table.Combine({#"Renamed Columns", Table2}),
    #"Grouped Rows" = Table.Group(#"Appended Query", {"Column2"}, {{"Total", each List.Sum([Column3]), type number}})
in
    #"Grouped Rows"

File is attached for your analysis