Create a table with columns from

[Kristofferaabo]

Hi!
I have three tables (A, B and C), they all have many columns that I use for other stuff but I would like to be able to create a MASTER table pulling three colunms out and merging them into one table.

Columns names are: 'Project, Company, 'country'

None of these tables are connected

Is it ADDCOLUMNS? Summarize or do I have to make three identical tables and then 'append' or merge?

Any help/ideas are highly appreciated

Kristoffer

[v-ljerr-msft]

Hi @Kristofferaabo,

Based on my test, you should be able to use the formula below to create the calculate table in your scenario. 

Table =
CROSSJOIN (
    SELECTCOLUMNS ( 'TableA', "Project", 'TableA'[Project] ),
    SELECTCOLUMNS ( 'TableB', "Company", 'TableB'[Company] ),
    SELECTCOLUMNS ( 'TableC', "Country", 'TableC'[Country] )
)

Regards