Repeat Date Values for Each Unique Part Number

Hi Anonymous 

You seem to need a crossjoin of the two tables.  Check this out:

https://exceleratorbi.com.au/cross-join-with-power-query/

Hey, 

basically the answer is in a way simple, but also by no measn obvious :-)

Here are some screenshots how to expand the Calendar table with Part Number column from the Parts table.

Select the Calendar table and choose the command "Custom Column" from the Add Column menu:

And just type the name of the Parts table ...

It does not matter how you name the column, after you choose OK, the Calendar table should look like the:

just hit the "expand" icon, and the next dialog will look like this:

This dialog allows to select the columns you want to "select" from the Parts table.

Personally I prefer to deselect naming option, but this is my personal taste. After choosing "OK" you're done ...

You're done!

Please be aware that this is the simplest of all possible joins, creating a cartesian product of combinations. This often is quite useful, but be sure that you want what you get, meaning you should consider if the result is also valid if the rows in both tables are not unique ...

Regards,

Tom