How can i create table with list from other table and date with group by month

[chernetsovalex]

Hello.

I have 2 tables:

1 table with dates with group by month:

let
    Years = Table.FromList({2018..2019}, Splitter.SplitByNothing(), null,null, ExtraValues.Error),
    AddMonth = Table.AddColumn(Years, "Month", each {1..12}),
    ShowMonths = Table.ExpandListColumn(AddMonth, "Month"),
    CreateDate = Table.AddColumn(ShowMonths, "Date", each #date([Column1],[Month],1))
in
    CreateDate

2 table with product list:

http://prntscr.com/occ6ne

How can i change 1 table to create a table of such a structure?

Date | Product list

1.01.18 | Diesel DZ100

1.01.18 | Diesel DZ101

1.01.18 | ......Products from table 2 list

1.01.18 | Diesel DZ999

1.02.18 | Diesel DZ100

1.02.18 | Diesel DZ101

1.02.18 | ......Products from table 2 list

1.02.18 | Diesel DZ999

Аnd so on

[MFelix · Accepted solution]

Hi @chernetsovalex ,

Go to the Table1 and add custom column with the following code:

Table2[Name]

This will give a list column then just click on Expand to new rows and the result is date and products.

check example attach.

Regards,

MFelix