Forum Discussion
Building huge data table from 2 smaller one efficiently.
Hi All!
I have a bit of a challange on how to combine huge data efficiently and build a report on top of that.
I have 2 lists both not too big in their own List Shops and List Products. We have like 150 shops for now and 370 products that are the same in all shops. How can I put all those in one table or connecting them in a way that the report will recognise all shops with all products? It will be 150*370 row of data, but I dont know how to combine them in this way inside PowerBI.
For example:
Shop A Product 1
Shop A Product 2
...
Shop A Product 370
Shop B Product 1
...
Shop B Product370
... and so on...
Anonymous, 150*370 is not a big table...
I believe what you are trying to achieve is called "cartesian join". Here is a solution:
https://radacad.com/cartesian-product-in-power-query-multiply-all-sets-of-all-pairs-in-power-bi
2 Replies
Anonymous, 150*370 is not a big table...
I believe what you are trying to achieve is called "cartesian join". Here is a solution:
https://radacad.com/cartesian-product-in-power-query-multiply-all-sets-of-all-pairs-in-power-bi