join cells in a column by month and year

[nicolasvc]

I have a table with a list of products and another that I generate the months and years, and I need to create a table where the products are for each month and year, as shown. How could I do it using DAX?

Product

A

B

C

Year	Month
2022	1
2022	2
2022	3
...	...
2023	12

Result

Year	Month	Product
2022	1	A
2022	1	B
2022	1	C
2022	2	A
2022	2	B
...	...	...

[MFelix · Accepted solution]

Hi @nicolasvc ,

Using DAX you can use the CROSSJOIN sintax:

Table 2 = CROSSJOIN('Table1', 'Table2')

[HotChilli]

In Power Query, add a custom column to the second table (using the interface).  In the dialog box put the name of the first table.

In the next step, expand the table (from the column header).

That should do it