Forum Discussion
Creating Column in Table View Combining Two Tables with same ids but one with duplicates
I have two tables as depicted in the visuals here. As you can see table 2 has a mix of blanks and additional entries. I need table A exactly as is but with the blanks removed and additional entries f...
Anonymous Hi try it 2 calculate table
CombinedTable =
FILTER (
UNION (
SELECTCOLUMNS ( 'Table 1', "ID", 'Table 1'[Col1], "Value", 'Table 1'[Col2] ),
SELECTCOLUMNS ( 'Table 2', "ID", 'Table 2'[Col1], "Value", 'Table 2'[Col2] )
),
NOT ISBLANK ( [ID] )
)and
NeededTable =
SUMMARIZE (
CombinedTable,
CombinedTable[ID],
"CombinedValues", CONCATENATEX (
VALUES ( CombinedTable[Value] ),
CombinedTable[Value],
","
)
)Thanks for the reply. For the 1st one i get an error. The expression refers to muliple columns. Multiple columns cannot be converted to a scalar value
Anonymous Hi, Show your DAX code