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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
86 | |
77 | |
70 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |