nareshr89Helper II3 years agoSolvedVirtual Table 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...Show Moretamerj13 years agoHi nareshr89 Please try New Table = GROUPBY ( UNION ( Table1, Table2 ), [ML], [Region], "TR", SUMX ( CURRENTGROUP (), [TR] ), "OR", SUMX ( CURRENTGROUP (), [OR] ), "FTEs", SUMX ( CURRENTGROUP (), [FTEs] ) )
tamerj13 years agoHi nareshr89 Please try New Table = GROUPBY ( UNION ( Table1, Table2 ), [ML], [Region], "TR", SUMX ( CURRENTGROUP (), [TR] ), "OR", SUMX ( CURRENTGROUP (), [OR] ), "FTEs", SUMX ( CURRENTGROUP (), [FTEs] ) )
tamerj13 years agoHi nareshr89 Please try New Table = GROUPBY ( UNION ( Table1, Table2 ), [ML], [Region], "TR", SUMX ( CURRENTGROUP (), [TR] ), "OR", SUMX ( CURRENTGROUP (), [OR] ), "FTEs", SUMX ( CURRENTGROUP (), [FTEs] ) )
Related contentFabric virtual tableDax Logic Issue virtual TableDataverse Virtual table link to FabricGA availability for streaming connector virtual networkSummarize virtual table
