Combine columns btw 3 tables.

[Annie2310]

I have 3 tables,

Each has different columns and rows.

But both three 3 tables have column name "X" with value

Now I want to have a new column that includes full information of column "X" of three tables and remove duplicate values.

Could you please advise?

[Samarth_18 · Accepted solution]

Hi @Annie2310 ,

You could a new table like this:-

Table_new = 
DISTINCT (
    UNION (
        VALUES ( 'Table'[X] ),
        VALUES ( 'Table (2)'[X] ),
        VALUES ( 'Table (3)'[X] )
    )
)