Appending Table in Query Editor for each Group

[Fraze]

I have 2 tables in Query Editor:

(1) 

(2) 

How do I append these tables together so each Customer has a calendar list like below?

Dates	Customer
1/1/2021	A
1/2/2021	A
1/3/2021	A
1/4/2021	A
1/5/2021	A
1/6/2021	A
1/7/2021	A
1/8/2021	A
1/9/2021	A
1/10/2021	A
1/11/2021	A
1/12/2021	A
1/13/2021	A
1/14/2021	A
1/15/2021	A
1/16/2021	A
1/17/2021	A
1/18/2021	A
1/19/2021	A
1/20/2021	A
1/21/2021	A
1/22/2021	A
1/23/2021	A
1/24/2021	A
1/25/2021	A
1/26/2021	A
1/27/2021	A
1/28/2021	A
1/29/2021	A
1/30/2021	A
1/31/2021	A
1/1/2021	B
1/2/2021	B
1/3/2021	B
1/4/2021	B
1/5/2021	B
1/6/2021	B
1/7/2021	B
1/8/2021	B
1/9/2021	B
1/10/2021	B
1/11/2021	B
1/12/2021	B
1/13/2021	B
1/14/2021	B
1/15/2021	B
1/16/2021	B
1/17/2021	B
1/18/2021	B
1/19/2021	B
1/20/2021	B
1/21/2021	B
1/22/2021	B
1/23/2021	B
1/24/2021	B
1/25/2021	B
1/26/2021	B
1/27/2021	B
1/28/2021	B
1/29/2021	B
1/30/2021	B
1/31/2021	B

[AlexisOlson]

This is called the Cartesian Product or Cross Join of two tables.

The second link above includes screenshots for the steps in the solution @parry2k provides.

[parry2k · Accepted solution]

@Fraze in table 1 add a custom column and when the custom column windows open, enter the name of your 2nd table, and you will see the custom column as a table, expand it and you will get what you are looking for.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡