How to duplicate tables for another tables values

[Anonymous]

I have a table that does not contain a date column. The value in that column is consisitent for the entire year, but the report is filtered by month. As a result, I cannot visualze values from this table in a monthly report. Therefore, what I am trying to do is the following.

I have two tables Saving Target and Dates as follows:

Suppliers	Target in $	
Heck		255.00
Yummy		650.00
Dual		587.35	


Date
1/4/2021
2/4/2021
3/4/2021
4/4/2021
.
.
.

The desired output is as follows:

Suppliers	Target in $		 Date
Heck		255.00			1/4/2021
Yummy		650.00			1/4/2021
Dual		587.35			1/4/2021
Heck		255.00			2/4/2021
Yummy		560.00			2/4/2021
Dual		587.35			2/4/2021
Heck		255.00			3/4/2021
Yummy		650.00			3/4/2021
Dual		587.35			3/4/2021
.				.				.
.				.				.
.				.				.

Can anyone help me with this please?

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please try the below for creating a new table.

New Table = CROSSJOIN('Saving Target', Dates)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM