topic Re: Virtual Table in DAX Commands and Tips

Virtual Table

nareshr89 — Tue, 21 Feb 2023 13:18:26 GMT

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.

Re: Virtual Table

tamerj1 — Tue, 21 Feb 2023 14:00:57 GMT

Hi nareshr89
Please try

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

Re: Virtual Table

nareshr89 — Wed, 22 Feb 2023 13:57:08 GMT

Thanks tamerj1 for the solution. It worked as expected