Append table with no matching columns

Question

I am trying to a new table out of two exisiting tables. Table 1 has all the dates &amp; Table 2 has the department &amp; cost.&nbsp; All the departments &amp; costs are static for the year but I need there to be a department and cost for each date (see example). Is there a way to append or merge these tables?&nbsp;TABLE 1:&nbsp;&nbsp;DATE&nbsp;&nbsp;11/4/2022&nbsp;&nbsp;11/18/2022&nbsp;&nbsp;12/2/2022&nbsp;&nbsp;12/16/2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TABLE 2:&nbsp;&nbsp;DEPTCOST&nbsp;154&nbsp;$&nbsp;&nbsp;&nbsp; 10.00&nbsp;654&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.00&nbsp;102&nbsp;$&nbsp;&nbsp;&nbsp; 14.00&nbsp;&nbsp;&nbsp;&nbsp;RESULT:&nbsp;&nbsp;DATEDEPTCOST11/4/2022154&nbsp;$&nbsp;&nbsp;&nbsp; 10.0011/4/2022654&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.0011/4/2022102&nbsp;$&nbsp;&nbsp;&nbsp; 14.0011/18/2022154&nbsp;$&nbsp;&nbsp;&nbsp; 10.0011/18/2022654&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.0011/18/2022102&nbsp;$&nbsp;&nbsp;&nbsp; 14.0012/2/2022154&nbsp;$&nbsp;&nbsp;&nbsp; 10.0012/2/2022654&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.0012/2/2022102&nbsp;$&nbsp;&nbsp;&nbsp; 14.0012/16/2022154&nbsp;$&nbsp;&nbsp;&nbsp; 10.0012/16/2022654&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7.0012/16/2022102&nbsp;$&nbsp;&nbsp;&nbsp; 14.00

jihwan_kim · Accepted Answer

Hi,
Please check the below picture and the attached pbix file.
&nbsp;

&nbsp;
Result table = 
GENERATE( 'Table 1', 'Table 2' )
&nbsp;
&nbsp;

Forum Discussion

Append table with no matching columns

1 Reply

Related content

Dataflow - Append

Matching Column Values

Appending columns and creating new column of old column headers

Appending Data

Append Column to row derived from the from three columns

TABLE 1:
DATE
11/4/2022
11/18/2022
12/2/2022
12/16/2022

TABLE 2:
DEPT	COST
154	$ 10.00
654	$ 7.00
102	$ 14.00

RESULT:
DATE	DEPT	COST
11/4/2022	154	$ 10.00
11/4/2022	654	$ 7.00
11/4/2022	102	$ 14.00
11/18/2022	154	$ 10.00
11/18/2022	654	$ 7.00
11/18/2022	102	$ 14.00
12/2/2022	154	$ 10.00
12/2/2022	654	$ 7.00
12/2/2022	102	$ 14.00
12/16/2022	154	$ 10.00
12/16/2022	654	$ 7.00
12/16/2022	102	$ 14.00