assign each date to each code

Hi Anonymous,

Result:

Create blank query, open it in Advanced editor end edit 1st and 2nd step. Delete whole code (as selected on the picture below) in these 2 steps and replace it with names of your tables

let
    Table_ID = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("LcqxCoAgFIXhd3HuDkfvvdgcNQUNQQniltEm5PtDgXKm/+PEaKZzoRDCPps0/LXmp5KwQkWl0ZZLBnmBRYODQeL5n0D7pziCs55HdbaTqxfdr4eATUof", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t]),
    Table_WeekStartDate = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Vc7BCcAwDEPRXXwuWFbjksxisv8azc3R8cEXqMq4HOEEh+2nDOlgM6hcQn5CDMd7xaGcQqbwfDjz5hRGNvcP", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Week_Start_Date = _t]),
    #"Added Custom" = Table.AddColumn(Table_ID, "Custom", each Table_WeekStartDate),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Week_Start_Date"}, {"Week_Start_Date"})
in
    #"Expanded Custom"

Hi Anonymous ,

Have you solved your problem?
If not, please try this way:

Date[Week_Start_Date]

The final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

=#table({"ID","Week_Start_Date"},List.TransformMany(Table1[ID],each Table2[Week_Start_Date],(x,y)=>{x,y}))