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