Create combinations from multiple lists – Cartesian product – Power Query
Learn two ways of combining multiple lists and creating all combinations. Pivot table or Power Query? I prefer Power Query. Download sample file and try. Related Videos Convert crosstab data to tabular – Excel | Power BI | Power Query How to Convert EDL to Excel or Power BI in Power Query – Edit Decision […]
The post Create combinations from multiple lists – Cartesian product – Power Query appeared first on Efficiency 365.
Published on:
Learn moreRelated posts
Migrate Power BI Dataflow Gen1 to Fabric Dataflow Gen2
Unfortunately, there isn’t a migration tool to convert your Power BI dataflow (gen1) to Microsoft Fabric dataflow (gen2). If you have Fa...
Tips and Tricks for Integrating Power BI with Excel
Introduction Struggling to make sense of your data? You’re not alone. Many businesses find themselves are overwhelmed with information b...
REFRAME in Power BI Direct Lake
Power BI offers a new type of connection to Microsoft Fabric Lakehouse or Warehouse, called Direct Lake. The Direct Lake connection acts like ...
Exploring Advanced Relationship Properties In Power BI Copilot
I’ve been playing around with Power BI Copilot a lot recently, and following on from my recent posts on tuning Copilot by editing the Li...