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
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 257 members 2,098 guests
Please welcome our newest community members: