Expand tables - PowerQuery or M

[albalpbi]

Hello everyone,

I have two tables: one with dates and one with a list of countries. Example:
Table 1

Date

1/1/2022

1/2/2022

1/3/2022

Table 2

Countries

France

Germany

Italy

I'm trying to expand the first table in order to have, for each date, all the countries listed in Table 2. The target table would look like:

Date	Countries
1/1/2022	France
1/1/2022	Germany
1/1/2022	Italy
1/2/2022	France
1/2/2022	Germany
1/2/2022	Italy
1/3/2022	France
1/3/2022	Germany
1/3/2022	Italy

Would you know how to help me?

Thank you!

[Ahmedx]

try to do the opposite, that is, translate the date into the country table

[Ahmedx]

pls try this

[albalpbi]

In PowerQuery it seems to work, but when I "Close & Load" the laod just keeps on going endlessly:

Consider that the largest table in this dataset is 2Gb, and the table we're creating is about 10k rows (40 countries over 250 dates), so I'm not sure about what's going