by Gil Raviv | Jun 2, 2016 | Popular
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 me: List.Accumulate(list as list, seed as any, accumulator as function) as any Argument Description list...
by Gil Raviv | Jan 13, 2016 | Popular, Unpivot - The definitive guide
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 challenge: How to split comma-separated values in Power Query. We have a table of event names, dates and...
by Gil Raviv | Jan 3, 2016 | Unpivot - The definitive guide
Get ready to be amazed 🙂 This is the fourth post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you through one of the coolest data transformation features in Excel – The Unpivot transformation. Powered by Power...
by Gil Raviv | Jan 3, 2016 | Unpivot - The definitive guide
This is the third post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you through one of the coolest data transformation features in Excel – The Unpivot transformation. Powered by Power Query technology, the...
by Gil Raviv | Jan 3, 2016 | Unpivot - The definitive guide
Back to school with Excel & Power Query This is the second post in the series The Definitive Guide to Unpivot with Power Query in Excel. For today’s post I picked a topic which is quite actual for many of us. Our kids were recently back to school. By now...