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
How I Built a Full Power BI Semantic Model in Minutes Using Agentic AI and GitHub Copilot
In this second part of my blog series, I will show you how I edited the required files and then created my semantic model by using the Agentic...
A whirlwind tour on User-context-aware calculated columns in Power BI!
Bye, bye translation headaches! With the new User-context-aware calculated columns, we can tackle certain challenges more convenient than ever...
Parameter types in DAX user defined functions UDF
Power BI Semantic Model Refresh Warnings
Since March 2026, Power BI semantic models have started showing warnings in their Refresh History in the Service. This has scared a few people...
🚀 Power BI for Beginners (2026): Complete Day 1 Guide to Start Your Data Analytics Career
30 Days of Power BI - Day 1 Introduction Your comprehensive journey to mastering Microsoft Power BI begins today. Transform raw data into act...
How to Set Up Agentic Semantic Model Development for Power BI Using GitHub Copilot on Windows
I was inspired and in awe after watching the video that Rui Romano posted in LinkedIn where Rui shared a video on how he used Agentic model de...
Agentic AI in Power BI and Fabric, Part 2: Getting Started with VS Code, GitHub Copilot, and Safe MCP Setup
A Personal Note Before We Continue Before I continue this series, I want to briefly share why it took me so long to publish this second blog. ...
Power BI And Support For Third Party Semantic Models
I’ve been working with Microsoft BI tools for 28 years now and for all that time Microsoft has been consistent in its belief that semantic mod...
Microsoft Viva: Unlocking Deeper Copilot Insights with Enhanced Power BI Filtering
Enable Global and Insights admins to turn on additional attributes as filters in Power BI reports, including reserved attributes and your orga...