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...
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...
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...
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...
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...
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...