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
Microsoft Entra ID single sign-on for the Starburst connector in Power BI (Preview)
When enabling Microsoft Entra ID single sign-on (SSo) for Starburst (Preview) report viewers querying semantic models in DirectQuery mode auth...
Workspace outbound access protection for Power BI reports (Preview)
Workspace outbound access protection (OAP) is a workspace-level control in Microsoft Fabric that lets you constrain where the data inside a wo...
Org apps with audiences for Power BI and Fabric (Generally Available)
Announcing general availability of org apps in Power BI and Fabric, including one of the most requested capabilities: audiences.
Power BI Multilingual Reports Made Simple with User-Context-Aware Calculated Columns
Building a multilingual Power BI report has always been one of those requirements that sounded simple but turned out painful to implement. A F...
Simplified Oracle connectivity in Power BI (Preview)
Connecting Power BI to Oracle has historically meant extra provider installations and data gateway deployment — even for cloud-hosted database...
Migrating from embedded ODBC drivers to ADBC in Power BI and Fabric
If you use connectors like Databricks, Snowflake, or BigQuery in Power BI or Fabric, there’s an important change coming. Microsoft is moving f...