Append table with no matching columns

[jdiruzza]

I am trying to a new table out of two exisiting tables. Table 1 has all the dates & Table 2 has the department & cost.  All the departments & 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?

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

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Result table = 
GENERATE( 'Table 1', 'Table 2' )