Combining data and dates from different tables

[Tuna123]

I've got two tables: date table with next year's months and a data table for different products. I'm trying to create a new table by combining product data and dates (to calculate a forecast for each month and product).

Is this possible to do without having a relationship between the tables? Basically, I need to assign all of the dates in the date table to each product in product data.

[v-yulgu-msft · Accepted solution]

Hi @Tuna123,

You can create a calculated table via CROSSJOIN.

For example:

New table= CROSSJOIN(DateTable, ProductTable)

Best regards,
Yuliana Gu