Forum Discussion
Expand tables - PowerQuery or M
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!
3 Replies
pls try this
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
try to do the opposite, that is, translate the date into the country table
