New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

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?
Previous Promote a row to a column in Power Query – Part 2
Next Split multiple columns into rows without errors in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents