Forum Discussion

Kristofferaabo's avatar
Kristofferaabo
Icon for Helper IV rankHelper IV
8 years ago

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 t...
Need Help
Show and Tell
Tips and Tricks
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Kristofferaabo,

 

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

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

 

Regards