Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello community,
i have issue with preparing data for analyzing combination of them.
I have excel/csv table with 1 column and approximately 1500 rows. And would like to make table with two columns. It will be combination of all options. Thats 1500x1500 = 2 250 000 rows.
I make simple example with 3 rows, thats mean 9 combinations.
I think so the best way to do that is in Power Query.
Does anybody have any idea how to do that?
Thanks for your help and time
Milan
Solved! Go to Solution.
Hi - yes, that is possible in PowerQuery:
= #"Changed Type"
See my example, where my previous step was "Renamed Columns":
I hope that helps. Let me know if any steps were unclear.
If this solved the issue, please mark my post as a solution.
Thanks!
Yep. This is what MS documentation suggests too.
https://learn.microsoft.com/en-us/power-query/cross-join
@Milan Just FYI, this type of transformation is called a "cross join" or a "Cartesian product" of a table/list with itself.
Hello, guys. Thanks for your help.
Hi - yes, that is possible in PowerQuery:
= #"Changed Type"
See my example, where my previous step was "Renamed Columns":
I hope that helps. Let me know if any steps were unclear.
If this solved the issue, please mark my post as a solution.
Thanks!
Yep. This is what MS documentation suggests too.
https://learn.microsoft.com/en-us/power-query/cross-join
@Milan Just FYI, this type of transformation is called a "cross join" or a "Cartesian product" of a table/list with itself.
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |