combine specifc column from different table

[mhdilyas]

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 column

[Ashish_Mathur]

Hi,

This should ideally be done in the Query Editor.

[Anonymous]

Hi @mhdilyas ,

Please try below steps:

1. below is test table

Table:

Table2:

Table3:

2. create a table with below dax formula

Table 4 =
VAR tmp1 =
    SELECTCOLUMNS ( 'Table', "P1", [Product] )
VAR tmp2 =
    SELECTCOLUMNS ( 'Table 2', "P2", [Product] )
VAR tmp3 =
    SELECTCOLUMNS ( 'Table 3', "P3", [Product] )
VAR tmp4 =
    UNION ( tmp1, tmp2, tmp3 )
RETURN
    SELECTCOLUMNS ( tmp4, "Product", [P1] )

Please refer the attached .pbix file.

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.

[mhdilyas]

It did work thanks for support.

How to remove doublicate value and emply column

[Anonymous · Accepted solution]

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.

[mhdilyas]

I manage  dublicate value and empty but not able to null column due to this not able to create relationship

[mhdilyas2008]

how do i remove null value, without this i cannot create relation in between two table

plz im looking option without quereditor

[Arul]

@mhdilyas ,

Your explanation to the requirement is not clear. Could you please provide more context on this?

Thanks,

Arul

[Legend_11]

Explain issue, you want to append new table which is also having common column but you do not want all columns only specific columns?