Merging two tables in powerquery that absolutely have nothing in common

[Anonymous]

Hi all,

I have one table that contains just one column with year and month:

Year And Month

2018-01

2018-02

2018-03

….

And I have one table with my customer ID’s

Customer ID

A1

B2

C3

….

I want to combine both tables together in one new table in Powerquery. End result should look like this:

Year And Month	Customer ID
2018-01	A1
2018-02	B2
2018-03	C3
2018-01	A1
2018-02	B2
2018-03	C3
2018-01	A1
2018-02	B2
2018-03	C3

How to do that?

[Nolock]

Hi @Anonymous,

are you sure with the expected result? The three first lines repeat three times...

[Anonymous]

Hi @Nolock ,

Yes very sure about that. In Excel it's so easy to do, but i just don't know how to pull it off using PowerQuery.

Cheers

Bas

[Nolock · Accepted solution]

Hi @Anonymous,

ok, then try following:

1. Create an index column in the table YearAndMonth.
2. Create an index column in the table CustomerId.
3. Merge both tables via the new index column.
4. Remove columns which you don't need.

I've created a PowerBI file containing all what I have described: PowerBI file

A screenshot of creating an index:

And a screenshot of merging:

[Anonymous]

Hi @Nolock ,

That's a brilliant workaround, I would have never thought about that.

Thanks so much for helping me with finding the right solution!