For those of you looking for the LAG function from SQL in Power Query to get a previous record in a column, look no further than this article: https://gorilla.bi/power-query/get-previous-row-value/
SQL
“LAG ( [Column] ) OVER ( ORDER BY [Column] ) ”
=
Power Query
“= StepName[ColumnName]{ZeroBasedIndex}”
#SQL #PowerQuery