cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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

1 REPLY 1
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 =
CROSSJOIN (
    SELECTCOLUMNS ( 'TableA', "Project", 'TableA'[Project] ),
    SELECTCOLUMNS ( 'TableB', "Company", 'TableB'[Company] ),
    SELECTCOLUMNS ( 'TableC', "Country", 'TableC'[Country] )
)

 

Regards

Helpful resources

Announcements
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: