Virtual Table

[nareshr89]

I need a help creating a virtual table where Table 1 and Table 2 have same column names.

I want the certain columns to add up the values, meanwhile the remaining column to remain same. Sample tables shared below. Third table is expected final table.

[nareshr89]

Thanks @tamerj1  for the solution. It worked as expected

[tamerj1 · Accepted solution]

Hi @nareshr89 
Please try

New Table =
GROUPBY (
    UNION ( Table1, Table2 ),
    [ML],
    [Region],
    "TR", SUMX ( CURRENTGROUP (), [TR] ),
    "OR", SUMX ( CURRENTGROUP (), [OR] ),
    "FTEs", SUMX ( CURRENTGROUP (), [FTEs] )
)