Add table for each row in another table

BlackBird 

Try Cross Join function

CROSSJOIN(
VALUES(TABLE1[DATE]_,
VALUES(TABLE2[CONTRACTS)
)

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn

If you have a Dates and Contracts table as shown, in the Dates table, simply add a custom column in Power Query, then type =Contracts as your formula. It will initially look like this:

You an see the formula above just references the Contracts table. (if your table has a space in it, it would be ...each #"New Contracts")

Then just expand the Contracts column.

Hi, BlackBird 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

You may create a calculated table as below.

Table = 
GENERATE(
    'Date',
    'Contracts'
)

Result:

Best Regards

Allan

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