Forum Discussion
Solved
Create a custom table from 3 dimensions
Hi all, I would like to create a 3 columns table in Power Query giving the complete combinations from 3 dimensions. E.g.: - Agent : Bob, Cathy, Bernie (actually this list could contain 100 names) ...
This is called a Cartesian product or a cross-join.
You can use this method twice for 3 dimensions:
Cross join - Power Query | Microsoft Learn
This is called a Cartesian product or a cross-join.
You can use this method twice for 3 dimensions:
Cross join - Power Query | Microsoft Learn
So easy 🙂
Thanks a lot !
