Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Kristofferaabo
Helper IV
Helper IV

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
Employee
Employee

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.