Showing results for 
Search instead for 
Did you mean: 

Create a table with columns from

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



v-ljerr-msft Super Contributor
Super Contributor

Re: Create a table with columns from

Hi @Kristofferaabo,


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

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



Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 316 members 3,474 guests
Please welcome our newest community members: