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
Using Fabric Operations Agents And Workspace Monitoring With Power BI
This week, in the announcement about support for Fabric Pipelines in Workspace Monitoring, I noticed that it came with an Operations Agent tha...
Power BI on a Mac: I Love It
I Put 11 Power BI Secrets to The EXPERT Test
Microsoft Viva: Create and customize Power BI reports
Microsoft Viva Insights will allow eligible users to create, customize, and save supported Power BI reports, including adjusting periods, filt...
The Benefits Of Using Direct Lake Mode In Power BI
This is a blog post I’ve been meaning to write for a long time. Since Fabric launched there has been a lot of focus on Direct Lake mode ...
Optimising DAX: Model Design Comparisons and Testing Tips
Star schema vs flat table vs header/detail - which Power BI model design gives you the best performance? This post compares all three and cove...
Tips to Export Data To Data Lake From MS Dynamics 365 CE And Use It In Power BI.
Integrating Dynamics 365 with Azure Data Lake allows you to continuously sync operational data for cost-effective big data analytics, AI workl...