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:

Links to the mentioned resources
Here is an example of promoting rows with this technique:

Was this helpful?
Reader Interactions