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...
Tag: List.Generate
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...
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...
Excel Matrix Multiplication – Replacing MMULT with Power Query
In my last Thank You post, I suggested that Matrix multiplication is not Excel's forte. Following that post, I got a cool Power Query solution from Imke...
