Forum Discussion
Appending Table in Query Editor for each Group
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 |
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.⚡
2 Replies
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.⚡
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.
