Return Previous Row Value in Power query

This video breaks down how you can return the previous row in Power Query. In Excel a reference to the earlier row is easily made. In Power Query this takes a different approach. This video shows you how you get the previous row for single and multi leveled hierarchies. Enjoy!

WRITTEN BLOGPOST:
https://gorilla.bi/power-query/get-pr...

Master Functions and Syntax in M
https://powerquery.how

Chapters
00:00 Introduction
00:09 A single level hierarchy
00:38 Return the previous row
02:23 Calculate mutation versus previous row
04:08 A multi level hierarchy
04:30 Get the previous row for each level
08:31 Calculate mutation versus previous row


ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: https://paypal.me/rickmaurinus.

Website: https://gorilla.bi

SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...

LET'S CONNECT:
Blog: https://gorilla.bi
Facebook:   / bigorilla  
Twitter:   / rickmaurinus  
LinkedIn:   / rickmaurinus  

Thank you for your support!

#PreviousRow #PowerQuery #IndexColumn