Create a new table with rows for each ID

[Anonymous]

I have a calendar table that I would like to combine with a list of unique names from another unrelated table.

Inputs:
Date Table

Name Table                       

Desired Outcome:

Output Table

Thank you for your assistance!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Thank you Ashish, this worked amazingly well! Thanks for teaching me something new!

[Ashish_Mathur]

You are welcome.

[HotChilli]

CROSSJOIN?