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.
It did work thanks for support.
How to remove doublicate value and emply column
I manage dublicate value and empty but not able to null column due to this not able to create relationship
how do i remove null value, without this i cannot create relation in between two table
plz im looking option without quereditor
