Forum Discussion
Solved
combine specifc column from different table
we have imported data from diffirent data source, all data table have one common column and want to append specific not all. Table1, table2, table 3 cul1, col2, cul3 append to new table in colu...
Hi mhdilyas ,
You just need modify the dax formula:
Table 4 = VAR tmp1 = DISTINCT ( 'Table'[Product] ) VAR tmp2 = DISTINCT ( 'Table 2'[Product] ) VAR tmp3 = DISTINCT ( 'Table 3'[Product] ) VAR tmp4 = SELECTCOLUMNS ( tmp1, "P1", [Product] ) VAR tmp5 = SELECTCOLUMNS ( tmp2, "P2", [Product] ) VAR tmp6 = SELECTCOLUMNS ( tmp3, "P3", [Product] ) VAR tmp7 = UNION ( tmp4, tmp5, tmp6 ) VAR tmp8 = FILTER ( tmp7, [P1] <> BLANK () ) RETURN SELECTCOLUMNS ( tmp8, "Product", [P1] )Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
This should ideally be done in the Query Editor.