SandyBLAdvocate II9 years agoSolvedCreate New Table from columns of different sizes I want to create a new table in powerbi that joins two columns from different tables and creates combination of all records from each column. Thanks for the help! Table 1: Months January 2017 ...Show MoreVvelarde to SandyBL9 years agoSandyBL A sample could be: Mytable=Crossjoin(Values(Table1[ColumnA]), Values(Table2[ColumnZ]))
Vvelarde to SandyBL9 years agoSandyBL A sample could be: Mytable=Crossjoin(Values(Table1[ColumnA]), Values(Table2[ColumnZ]))
Vvelarde to SandyBL9 years agoSandyBL A sample could be: Mytable=Crossjoin(Values(Table1[ColumnA]), Values(Table2[ColumnZ]))
VvelardeCommunity Champion9 years agoSandyBL Hi, Use this (Modeling-New Table) Table 2 = CROSSJOIN(Months,Accounts)
SandyBLAdvocate II to Vvelarde9 years agoThanks. How would I choose the specific columns in each table?VvelardeCommunity Champion to SandyBL9 years agoSandyBL A sample could be: Mytable=Crossjoin(Values(Table1[ColumnA]), Values(Table2[ColumnZ]))
SandyBLAdvocate II to Vvelarde9 years agoThanks. How would I choose the specific columns in each table?
VvelardeCommunity Champion to SandyBL9 years agoSandyBL A sample could be: Mytable=Crossjoin(Values(Table1[ColumnA]), Values(Table2[ColumnZ]))
Related contentCreate a Column where sum two columns from different tablesCreate columns groupCreate a Calculated Column from Different TablesDifferent schema into different destinationCreating a date column
