by Gil Raviv | Apr 9, 2018 | Book, Popular
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 pages so far). This weekend, after finishing 44 pages on M, I wanted to share with you, in this post, a...
by Gil Raviv | Oct 7, 2016 | Popular
Converting column types, and merging columns are common transformations in Power Query. It is so easy to perform these transformations through the Query Editor user interface (as we will demonstrate in a minute), but sometimes, the auto-generated Power Query...
by Gil Raviv | Jun 27, 2016 | Uncategorized
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 Pagination. We will demonstrate this technique on Facebook Graph API v2.6, but you can apply it on any APIs with...
by Gil Raviv | Jun 3, 2016 | Popular
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 fun to experiment with List.Generate and use it to implement a kind of a For-Loop. So I thought it would be cool...
by Gil Raviv | Jun 1, 2016 | Uncategorized
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 Feldmann, author of ThedBIccountant.com, that performs matrix multiplication with Power Query. So today I...
