Nested Loop with List.Generate in Power Query
Recently I shared a Matrix Multiplication Power Query technique here, and explained how to use List.Generate as the core step of the multiplication. It was...
Search Results for: List.Generate
Matrix Multiplication using the Cartesian product in Power Query
Guest Author: Henk-Jan van Well As a follow up to two older Matrix Multiplication posts here and here, I would like to share with you an alternative query...
Convert “Column1” to “A”
I admit that the technique I will share with you in this post may not have many use-cases, but it was a crucial component for the Excel Compare Power BI...
Book Excerpt: Loops, Recursions, Fibonacci and more from Chapter 9: M #PowerQuery
The draft of my book is almost ready (I even have few Excel formulas that are showing me, that I have already wrote 93% of the books, and a total of 359 draft...
Web Scraping Power BI Custom Visuals from AppSource using Power Query
Last week, Microsoft moved Office Store to App Source. As a result, all of the custom visuals of Power BI are now available in the new site. As promised...
Hurricane Harvey – Help for Victims on Facebook – As Seen in #PowerBI
As the impact of Hurricane Harvey unfolds, and the worst may yet to come, I was wondering if data can help in the rescue efforts, or at least encourage us...
Subscriber’s Corner
Welcome to DataChant Subsriber's Corner. From here you can access the main resources that are available for DataChant subscribers. To access any of the links...
Robust Queries: Convert column types and merge columns without referencing column names
Converting column types, and merging columns are common transformations in Power Query. It is so easy to perform these transformations through the Query...
Iterate over dynamic Web API Pages with Power Query – How to resolve Cursor-Based Pagination
In today's post, we will go over an advanced Power Query technique that will help you to import data from Web REST APIs that implement Cursor-Based...
Faster Matrix Mulitplication
As a followup for our recent Matrix Multiplication post here, I would like to share with you a faster query for Matrix Multiplication (Faster only...
