Create single column table from 2 tables

[Jo_Chrq]

Hi,

I have two tables, each one has a "Campaign name" column.

They share some campaigns but not all.

I would like to create a table with all campaigns :

Table 1

Campaign A

Campaign B

Campaign C

Table 2

Campaign A

Campaign D

Campaign F

Expected table :

Campaign A

Campaign B

Campaign C

Campaign D

Campaign F

Is there a way to do so?

Many thanks in advance

[amitchandak · Accepted solution]

@Jo_Chrq , create a new table

distinct(union(distinct(Table1[Campaign ]),distinct(Table1[Campaign ])))

[Jo_Chrq]

GREAT ! thank you