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...
Category: Popular
Power Query List.Accumulate – Unleashed
Following a reader's request, today we will unleash the power of List.Accumulate. The official documentation on List.Accumulate here was very confusing for...
Power BI Templates
Microsoft released today (29 April, 2016) a new update of Power BI Desktop with some new cool features here. In particular, I find the new Power BI templates...
Split and Unpivot Comma-Separated Values
By now, if you read my previous posts in the series The Definitive Guide to Unpivot in Excel (all posts here), you will feel confident with the following...
Unpivot ANY nested table and load to Power BI Desktop
Earlier today I shared with you a function query here that unpivots ANY nested table into Excel and transforms summarized tables into a PivotTable. This post...
Transform multiline records into a table
In today's post, there is a nice Power Query trick to transform multiline record data into a table in Excel. I intend to use this trick quite soon on my next...
