Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Hi @Kristofferaabo,
Based on my test, you should be able to use the formula below to create the calculate table in your scenario.
Table = CROSSJOIN ( SELECTCOLUMNS ( 'TableA', "Project", 'TableA'[Project] ), SELECTCOLUMNS ( 'TableB', "Company", 'TableB'[Company] ), SELECTCOLUMNS ( 'TableC', "Country", 'TableC'[Country] ) )
Regards
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |