Cartesian Product in Power Query: Multiply All Sets of All Pairs in Power BI
Sometimes, you need to create a multiplication of all sets of all pairs from two different data tables in Power BI. This action is different from Merge (Join) because there is no matching key columns and no way to relate the two tables together. However, you want to create a multiplication as a flatten table. Read more about Cartesian Product in Power Query: Multiply All Sets of All Pairs in Power BI[…]