Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
Hi @Anonymous,
ok, then try following:
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:
Hi @Anonymous,
are you sure with the expected result? The three first lines repeat three times...
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
Hi @Anonymous,
ok, then try following:
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:
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!
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |