Forum Discussion

Kristofferaabo's avatar
Kristofferaabo
Helper IV
8 years ago

Create a table with columns from

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

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi Kristofferaabo,

     

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

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

     

    Regards