Create table from columns of existing tables

[Pbiuserr]

Hello
Lets imagine I have bunch of referential tables, and I'd like to have one table consist of

Fcttbl[ID]
Ref_Product[Product]
Ref_Country[Country]
Ref_Category[Category]
Ref_Subcategory[Color]

All of these are connected to Fcttbl, but no other connections between them, if that count

Thank you in advance for your help

[johnt75 · Accepted solution]

I think you should just be able to use SUMMARIZECOLUMNS, like

New Table = SUMMARIZECOLUMNS(
Fcttbl[ID],
Ref_Product[Product],
Ref_Country[Country],
Ref_Category[Category],
Ref_Subcategory[Color]
)