Print

Get previous row in Power Query – EXPLAINED

You have asked me many times how the previous row works in Power Query, so in this video I will show you that and also a quick way to remember it.

Table of contents:

00:00 Intro & Problem description
00:28 Find the Previous row code in power query
00:46 Explaining the code for previous row
01:30 How to reference rows in power query
02:23 The solution
03:40 Manage errors for first or last rows

Watch the tutorial:

Get previous row in Power Query - EXPLAINED

Links to the mentioned resources

Here is an example of promoting rows with this technique:

Promote a row to a column - Part 2: Power Query Challenge
Was this helpful?

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents